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
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
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
[email protected]HIS
"Princey" <[email protected]> wrote in message
news:[email protected]...
>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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks