| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I convert the contents of a text selection from uppercase.
I have a column of data in my EXCEL spreadsheet that was retrieved from a
database. Unfortunately, all the data is in uppercase. I would like to easily highlight portions of the contents of each cell and replace it with the lowercase version of the selection. Does anyone have any suggestions or sample macro I could use? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I convert the contents of a text selection from uppercase.
Hi Phil,
See http://www.mvps.org/dmcritchie/excel/proper.htm#lower --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Phil Yandel" <Phil wrote in message ... I have a column of data in my EXCEL spreadsheet that was retrieved from a database. Unfortunately, all the data is in uppercase. I would like to easily highlight portions of the contents of each cell and replace it with the lowercase version of the selection. Does anyone have any suggestions or sample macro I could use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making all text into uppercase | Excel Discussion (Misc queries) | |||
| Changing the entire contents of my spreadsheet to uppercase | Excel Discussion (Misc queries) | |||
| Identify text in uppercase | Excel Worksheet Functions | |||
| How can I convert entire columns of text to Uppercase in Excel? | Excel Worksheet Functions | |||
Linear Mode
