Capitals

[Richard]

How do change a whole column from capitals into title
case?
IE: SMITH to Smith

Many thanks, Richard

 

[Frank Kabel]

Hi Richard
if your data is stored in column A put the following formula in B1
=PROPER(A1)
copy this formula down
Now select column B and copy this range. Goto 'Format - Paste special'
and paste these data as VALUE.
If you like delete the old columns

 

[JE McGimpsey]

If you have to do this repeatedly, check out David McRitchie's Proper
macro:

http://www.mvps.org/dmcritchie/excel/proper.htm

Alternatively, in a blank column, enter in cell 1:

=Proper(A1)

and copy down as far as necessary. Copy the column. Select column A and
choose Edit/Paste Special, selecting the Values radio button. Delete the
helper column.

 

[Richard]

Many thanks Frank, easy isnt it when you know how!

Regards, Richard