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

's Computer Specifications

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

's Computer Specifications

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 Removed)HIS

"Princey" <(E-Mail Removed)> wrote in message
news:9350848B-91A0-41EB-BD63-(E-Mail Removed)...
>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

's Computer Specifications

=proper(a1)

hth
regards from Brazil
Marcelo

"Princey" escreveu:

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert uppercase to proper name using update query	AShi	Microsoft Access Queries	4	30th Jul 2008 02:09 PM
How do I change uppercase to proper case in entire worksheet?	=?Utf-8?B?S2FyZW4=?=	Microsoft Excel Worksheet Functions	7	21st Oct 2005 12:31 PM
How to change text in multiple cells from Uppercase to proper cas.	=?Utf-8?B?RXhjZWwgaGVscA==?=	Microsoft Excel Worksheet Functions	1	17th Nov 2004 03:45 AM
converting uppercase to proper case	Susan	Microsoft Access	4	31st Mar 2004 11:30 PM
Forcing uppercase, proper case	Peter Bishop	Microsoft Excel Misc	2	22nd Oct 2003 09:27 AM