| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reformat my database from all uppercase to proper?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I reformat my database from all uppercase to proper?
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change uppercase to proper case in entire worksheet? | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Links to External Database | Excel Discussion (Misc queries) | |||
| Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
| How to change text in multiple cells from Uppercase to proper cas. | Excel Worksheet Functions | |||
Linear Mode
