Formatting Text

B

Bob Umlas

If your list is in D2:D200, for example, then enter this formula in an empty
column, row 2 (say G2):
=PROPER(D2), then fill down. Then copy G2:G200, select D2, use edit/paste
special, click Values, then OK. Then clear column G.

Bob Umlas
Excel MVP
 
R

RFJ

I've got a column list of about two hundred surnames - all printed in
capital letters.

Is there an easy way that I can convert or reformat this to an initial cap
and then lower case. eg :

From DAVIES
To Davies


TIA

Rob
 
B

Bernie Deitrick

Rob,

Insert another column, and use a formula like

=PROPER(A1)

copy down to match your data, then copy / pastespecial values and delete
your original data.

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

Bob,

I could have sworn that when I replied, there weren't any other replies :)

Or you're clairvoyant ;-)

Bernie
 
Top