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. |
=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. |
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. |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com