ExcelBanter - In excel, how do you convert to caps?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In excel, how do you convert to caps? (https://www.excelbanter.com/excel-discussion-misc-queries/27370-excel-how-do-you-convert-caps.html)

excel issue

In excel, how do you convert to caps?

How to I convert the spreadsheet to be all in caps?

Dave Peterson

I'd use a macro like Chip Pearson's:
http://cpearson.com/excel/case.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

excel issue wrote:

How to I convert the spreadsheet to be all in caps?

--

Dave Peterson

All times are GMT +1. The time now is 05:16 PM.