> We are having difficulty converting text which has been typed in all CAPS
> to Proper Case. The file consists of a simple mailing list, about 250 lines
> long. We are trying to change the first and last name columns to Proper
> case from UPPER case. Any help would be greatly appreciated.
> I normally use the following steps for similar cases:
1) Insert extra columns next to the First & Last name columns.
2) Enter the formula
in the first cell of the new column (where cell reference is the cell containing the text in
Uppercase). Then copy the formula down to the rest of the column. Do this for each column.
3) Copy the column containing the formula then choose Paste Special and values. This will
replace the formulae with the values. Again do this for each column.
4) Delete the columns with text in Uppercase.
And that should be it!
Hope this helps and is explained clearly enough.
Any opinions expressed are my own and do not necessarily reflect those of my employers