Formatting Text

[Bob Umlas]

If your list is in D2200, 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

 

[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

 

[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

 

[Bernie Deitrick]

Bob,

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

Or you're clairvoyant ;-)

Bernie