ExcelBanter - hOW DO i TURN TEXT INTO ALL CAPS?

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

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

- - hOW DO i TURN TEXT INTO ALL CAPS? (https://www.excelbanter.com/excel-discussion-misc-queries/209130-how-do-i-turn-text-into-all-caps.html)

big D

hOW DO i TURN TEXT INTO ALL CAPS?

I have written info in caps and lower case. I need it to be all caps. Is the
a command to get it to change?

Gary''s Student

hOW DO i TURN TEXT INTO ALL CAPS?

Say you have text in column A and want to convert it.

In B1 enter:

=UPPER(A1) and copy down

Then copy column B and paste/special/values back onto column A
--
Gary''s Student - gsnu200812

"big D" wrote:

I have written info in caps and lower case. I need it to be all caps. Is the
a command to get it to change?

David Biddulph[_2_]

hOW DO i TURN TEXT INTO ALL CAPS?

F1
Upper
--
David Biddulph

"big D" wrote in message
...
I have written info in caps and lower case. I need it to be all caps. Is
the
a command to get it to change?

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