Cleaning up Capitalization

Mary Ellen Cenzalli

We have a number of constituents that were entered in all caps that need to be cleaned up.  Does anyone know if there is a work around to do this globally?  Could I do an export and an import instead?

Thanks for your help.

Mary Ellen 

Stephanie Ulmer

Yes, I would do an export then fix the data and re-import it back into the system.

William Winkler

Yes, you can export into excel, use the proper function to fix them, then import them back in.

Matt Page

Be careful with the PROPER function. MACDONALD will go to Macdonald not MacDonald etc.



Matt