Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot change text to proper case using formula
I have used the formula before, but with this spreadsheet I had to use the
"data to text" function to split the whole name to first and last name columns. Now the proper case formula will not work. Any suggestions would be appreciated. Thanks, Dena |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot change text to proper case using formula
Do you mean
=PROPER(A1) doesn't work? What do you have in A1 and what result do you get? "LaDena" wrote in message ... I have used the formula before, but with this spreadsheet I had to use the "data to text" function to split the whole name to first and last name columns. Now the proper case formula will not work. Any suggestions would be appreciated. Thanks, Dena |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot change text to proper case using formula
What "data to text" function are you referring to? Do you by any chance mean
the Data/Text To Columns menu item? If so, where is your data at now? When you say the "proper case formula", do you mean the PROPER function? If so, where are you using it at. I think you will need to provide us with more information about your layout, what you have and what you are trying to do with it (so we have some idea of what you see when you look at your spreadsheet) before we can offer any reason advice. Rick "LaDena" wrote in message ... I have used the formula before, but with this spreadsheet I had to use the "data to text" function to split the whole name to first and last name columns. Now the proper case formula will not work. Any suggestions would be appreciated. Thanks, Dena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
how do i change a case to proper text in excel 2003 | Excel Worksheet Functions | |||
Use "PROPER" to change UPPERCASE text to Title Case on worksheet | Excel Worksheet Functions | |||
Excel: How do I change all upper case ss to proper case? | Excel Worksheet Functions | |||
how can I change case to Proper on a worksheet | Excel Discussion (Misc queries) |