paw

There are a couple of ways to change a column to UPPER case without using Word
as an intermediary.

1. In a helper column enter =UPPER(cellref)

Copy that down as far as you wish.

2. Use a macro to make the change in place.

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 09:30:02 -0800, pawprintzz
wrote:

Dear Mike, We are celebrating here in my office! Thanx for such an easy and
quick fix. I acutally have a headache from trying to work it in Excel - no
go! Bring it to Word, reformat it easily and bring it back to Excel. Thank
you from 3 of us!!

"Mike" wrote:

I would dump the column into Word then do Format - Change Case - UPPERCASE
then dump it back into Excel. I do not see this feature in Excel.

"dgysr" wrote:

I would like to select a column to incorporate only upper case letters. How
do I do this?