Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change from mixed caps and upper lower to all upper lower case
I have ever changing data base that imports as both mixed upper/lower and all
caps. I want to change all text to initial caps. Any formula in EXCEL to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change from mixed caps and upper lower to all upper lower case
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change from mixed caps and upper lower to all upper lower case
In a new column:
=PROPER(A1) Later, if you want, you can copy the formula column and Edit|Paste Special...|Values, you can paste the values over the original column. HTH Kostis Vezerides |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change from mixed caps and upper lower to all upper lower case
Thanks that works.
"Don Guillett" wrote: =proper -- Don Guillett SalesAid Software "Fish''s Mermaid" wrote in message ... I have ever changing data base that imports as both mixed upper/lower and all caps. I want to change all text to initial caps. Any formula in EXCEL to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upper Case Vs: Lower case | Excel Discussion (Misc queries) | |||
Excel: How do I change all upper case ss to proper case? | Excel Worksheet Functions | |||
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) |