Community
Showing results for 
Search instead for 
Do you mean 
Reply

Change Capitalization in fields

New Member
Posts: 16
Country: USA

Change Capitalization in fields

I imported a number of contact records from an Excel format. The names and addresses are all caps and does not look as I would like in my mail merges. Is there a quick way to change this or do I have to go in and re-type each record?

Silver Contributor
Posts: 1,813
Country: USA

Re: Change Capitalization in fields

There are ACT add ons available that may help you convert these (here).  Otherwise, before you do you import, in Excel, you can change the case to Proper Case (=PROPER(A1))
.  There is nothing built into the program to accomplish this.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Change Capitalization in fields

hEY jOHN -

 

hATE TO HAVE TO CORRECT YOU - OR AT LEAST ADD TO YOUR STATEMENT - BUT

 

wHILE WHAT YOU SUGGEST FOR FUTURE IMPORTS IS A GOOD SUGGESTION,

 

FOR THE DATA THAT IS ALREADY IMPORTED, THE FIELD TYPE COULD BE CHANGE TO "Initial-Caps".

 

This would at least make the data in ACT! look "normal".

 

PS - Keep in mind, as I recall, if you use this field in reports, it will still be ALL CAPS.