Capitals

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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

Many thanks, Richard
 
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
 
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.
 
Back
Top