Changing the format of a column
I have a column of names listed in capital letters. I would like to change
them so they are written correctly, i.e. JOHN DOE -- John Doe. Is there anyway that I can creat an input mask for the cells that will change the names to the format I want? |
Changing the format of a column
use the =proper() function in the next column
"MEAD5432" wrote: I have a column of names listed in capital letters. I would like to change them so they are written correctly, i.e. JOHN DOE -- John Doe. Is there anyway that I can creat an input mask for the cells that will change the names to the format I want? |
Changing the format of a column
For current data you can use the PROPER function as dlw points out.
OR you can use a macro to convert all at once in place without a foany formulas. For new data entries you can use event code to produce what you want as you type and enter. Post back if you want either of the latter two. Gord Dibben MS Excel MVP On Tue, 15 May 2007 08:19:00 -0700, MEAD5432 wrote: I have a column of names listed in capital letters. I would like to change them so they are written correctly, i.e. JOHN DOE -- John Doe. Is there anyway that I can creat an input mask for the cells that will change the names to the format I want? |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com