Initial Caps

[Guest]

I want to use the PROPER formula to initial cap all data in a column in a number of rows. Is there a way to do this? Thank you.

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/proper.htm

 

[Norman Harker]

Hi sbsmith!

You could use a helper column and use the function:

=PROPER(A1)

Once you have it, you can use:

Copy
Edit > Paste Special > Values
OK

The old data can then be deleted.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

I want to use the PROPER formula to initial cap all data in a column

in a number of rows. Is there a way to do this? Thank you.

 

[Gord Dibben]

Insert a helper column next to your data column.

Assume A is data column and B is helper column

In B1 enter =PROPER(A1)

Double-click on bottom right corner fill handle of B1 to copy down.

Select Column B and Copy then Paste Special>Values

Delete the original Column A.

If you have many columns to convert, use a macro like David McRitchie's PROPER
macro.

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

For help on getting started with macros see David's site

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

Gord Dibben Excel MVP