Convert text to upper case

**cooper72** · 07-18-2014, 08:53 AM

Is there a way of selecting text and converting it all from lower to upper case?

**zbor** · 07-18-2014, 08:54 AM

Try

Formula:

Please Login or Register  to view this content.

**zbor** · 07-18-2014, 08:55 AM

If you want to convert selected cells you must use VBA:

Right click on sheet name -> View code

and paste:

Please Login or Register  to view this content.

Then select any range and run this macro.

**Special-K** · 07-18-2014, 08:59 AM

VBA solution here, converts text once enter is pressed

http://excel.tips.net/T002568_Forcin...Uppercase.html

Re: Convert text to upper case