Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert a range of lowercase text to upper text or vice versa
i have a range of text some of which is in lowercase and some in uppercase.
i want to convert it all to uppercase text. is there an easy way to do this. |
#2
|
|||
|
|||
=UPPER(A1) and fill down, then copy these results, use paste special/values
on top of the original range, then clear these formulas. "jackdaw" wrote in message ... i have a range of text some of which is in lowercase and some in uppercase. i want to convert it all to uppercase text. is there an easy way to do this. |
#3
|
|||
|
|||
Hi Jack,
To change the data in place quickly, install macros so that you can use them anytime. http://www.mvps.org/dmcritchie/excel/proper.htm#upper Not familiar with installing and using macros? Top of page refers you to http://www.mvps.org/dmcritchie/excel/getstarted.htm --- 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 "Bob Umlas" wrote ... =UPPER(A1) and fill down, then copy these results, use paste special/values on top of the original range, then clear these formulas. "jackdaw" wrote ... i have a range of text some of which is in lowercase and some in uppercase. i want to convert it all to uppercase text. is there an easy way to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UPPER text function | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |