Initial Caps

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
sbsmith said:
I want to use the PROPER formula to initial cap all data in a column
Click to expand...
in a number of rows. Is there a way to do this? Thank you.
 
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
 
Back
Top