How do I reformat my database from all uppercase to proper?

G

Guest

I have downloaded a list of names and it is in all uppercase. I'm sure that
it can be converted in excel to PROPER, but I have tried and tried and cannot
make it happen. Anybody help me?

Thanks,

Princey
 
N

Nick Hodge

Princey

Use a helper column and enter the function

=PROPER(A1)

and copy down as far as you need

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I apply a function (PROPER) to multiple cells at once? 3
How do I change uppercase to proper case in entire worksheet? 7
uppercase to lowercase 4
how do i return to normal text from =PROPER(cell) 3
Using PROPER for Columns, rows or ENTIRE spreadsheet 3
Uppercase notation in access 2007 3
How do I change certain cells to Uppercase 4
Convert to uppercase 1

Top