Got it - thanks! Really appreciate the help!!!!!
--
Beth


"Mike H" wrote:

Beth,

=proper(a1) in b1 and dragged down would create a new column with your names
converted to proper case. This does what you want but you then have 2 columns
and can't delete the first because the formula refers to it so you can do
this.

You can copy the newly created column and then
select the original column
Edit|Paste special
paste values
delete the column with the formula in

Mike

"Beth" wrote:

Great, I see that function. Can I enter this function into a spreadsheet
that is already populated, or do I need to start new? Thanks!
--
Beth


"JuanMarin" wrote:

Hi,

you might want to try to PROPER() function for every cell, it will do
just what you need. HTH,

Juan Marin