Thread
:
How do I reformat my database from all uppercase to proper?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge
external usenet poster
Posts: 1,173
How do I reformat my database from all uppercase to proper?
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
HIS
"Princey" wrote in message
...
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge