ExcelBanter - All Caps

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

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

- - All Caps (https://www.excelbanter.com/excel-discussion-misc-queries/161897-all-caps.html)

flirodr

All Caps

I need to convert text in a column to all caps. How can i format the column
to All CAPS?

Thanks

David Biddulph[_2_]

All Caps

=UPPER(A1) and copy down.
--
David Biddulph

"flirodr" wrote in message
...
I need to convert text in a column to all caps. How can i format the
column
to All CAPS?

Thanks

Robnific

All Caps

Download James 2007 at www.allocator.nl All Cap text option
You are welcome

All times are GMT +1. The time now is 12:43 AM.