| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I cange text to lowercase in Excel
I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I cange text to lowercase in Excel
Search Help under PROPER and LOWER
A1 is "CAT DIED ON MONDAY, =PROPER(A1) gives "Cat Died On Monday" while =LOWER(A1) give "cat died on monday" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "photogirl96" wrote in message ... I have some imported data that came in all caps. Is there anyway to change the data to upper and lower case? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
| How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Linear Mode
