Capitalizing

[Katie]

Just a formatting question...

I type up my whole spreadsheet and later decide I want a
specific column to be ALL CAPS. Is this a format or a
formula?

 

[Max]

Assume specific column is col A

Try in say B1: =UPPER(A1)

Copy down

 

[Gord Dibben]

Katie

Formula. Cannot be done with formatting.

In a helper column enter =UPPER(A1) assuming column A is your column to be
changed.

Drag/copy down as far as you need.

When happy with results, copy the helper column then Paste Special(in
place)>Values>Ok>Esc.

Delete the original column.

Gord Dibben Excel MVP

 

[David McRitchie]

Hi Katie,
All Capitals is going to take up more space between
columns and it will not look very good unless it is something
like two letter codes like the US Postal Zip State codes.

I would use a macro to change the letter case for a selected
column or any other selection of cells.
http://www.mvps.org/dmcritchie/excel/proper.htm#upper