GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum


Home » GenoPro Help and Technical Support » Using GenoPro - How to... » How to capitalize surnames?


How to capitalize surnames?

Click to view RSS...
Author
RaymondM
Posted Friday, March 30, 2007 - Post #17169
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: Thursday, April 11, 2024
Posts: 9, Visits: 142
Attached is an Excel macro that changes all the document to upper case (capital letters).

If anyone else needs to capitalize, the required steps are:

1. Download the attached Excel Macro: Upper Case Macro.xls

2. You may need to change the security level for macros on Excel to Medium: Tools>Macro>Security... and Enable Macros when this file is opened.

3. Copy the required column that needs to be capitalized from the table layout into the Excel file.

4. On Excel select: Tools>Macro>Macros... and Run the Upper Case macro, this will change the document to upper case.

5. Paste the column back into the table layout.

Smooooth

Upper Case Macro.xls (54 views, 28.50 KB)

appleshaw
Posted Tuesday, March 27, 2007 - Post #17084
Grand Master

Grand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand Master

Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 4 hours ago
Posts: 1,584, Visits: 31,795
One option is to copy to a spreadsheet and use the UPPER function. Not so easy as having it built in
GenoProSupport
Posted Tuesday, March 27, 2007 - Post #17083
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Moderators
Customers
Gamma
FamilyTrees.GenoPro.com
Translator
GenoPro version: 3.1.0.1
Last Login: Thursday, January 16, 2025
Posts: 4,886, Visits: 22,775
At the moment, there is no easy way.  You can copy the surname column from the table layout into a spreadsheet, convert the text to uppercase, and paste the data back in the table layout.  When macros will be enabled in GenoPro, you will be able to do it using two lines of code, but macros won't be available before 2008.

Edited: Tuesday, March 27, 2007 by GenoProSupport
RaymondM
Posted Tuesday, March 27, 2007 - Post #17077
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: Thursday, April 11, 2024
Posts: 9, Visits: 142
How can surnames be capitalized?

It was suggested on another topic from 2004 that this will be available.



Similar Topics

Click to view RSS...
Expand / Collapse
No results found!

Reading This Topic

Expand / Collapse
Active: 3 - 1 guest, 2 members, 0 anonymous.
Refresh
Online: NiKo, gv


Powered By InstantForum.NET 2010-3-x © 2025
Execution: 0.016. 4 queries. Compression Enabled.