Convert names into initial caps
Hi
If your data is in column A, then in B1 (or any other spare column on
the sheet) enter
=Proper(A1)
Copy down as far as required.
Mark the range of cells in the column where you have put the formula,
which are now in Proper Form, move cursor to cell A1 and Paste
SpecialValues
You can then delete the helper column.
--
Regards
Roger Govier
"Grd" wrote in message
...
Hi there,
I have a column of names like SANDRA, JIM that I would like to convert
to
Sandra, Jim etc but I don't know how to do it and there are 3500 of
them.
Is there anyway to do this without retyping them?
Any help would be great.
Thanks
Connie
|