Capitalize Text

  • Thread starter Thread starter Lynda Hillborg
  • Start date Start date
L

Lynda Hillborg

I want to change all text in a worksheet to upper case. I
found the formula to use =upper(), but don't know where to
enter it. If I put it in the cell to be changed to upper
case it shows as a circular formula.

Any easier way to revise entier worksheet?
 
Well you never put any formula in the cell where the data to be worked on
is. if the text "apple" is in A1, you need to keep that text around long
enough to make them capital with =UPPER(A1) -- you can put this anywhere but
in A1. you can copy this down to capitalize any other cells too.

If you put it in B2, you can then go to B2, press CTRL-C (copy) then go to
edit>paste special and select VALUES.

You can paste this into A1, to overwrite the text 'apple' with the text
'APPLE'. Then you can delete the formula stuff.

Depending on the layout of your worksheet, this may work ok for you.

To do everything on the worksheet at once, I don't know how- maybe someone
can help you.
 
Lynda, to use the =UPPER you would need to put it in another column, say
your data is in column A ,in column B you would put =UPPER(A1) and copy
down, below is one way to do it with a macro, select the range you want to
change and run it, if you need help on where to put the macro and how to run
it post back

Sub CAPS()
'select range and run this to change to all CAPS
Dim cel As Range
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
End Sub
 
One quick way is to insert a helper sheet. Then in cell A1 of the helper sheet type

=UPPER(Sheet1!A1

Replace Sheet1 with your sheet name, if necesary. Then copy this formule to the right and down as far as you need. Select this entire sheet and COPY, Select A1 on your original sheet and Paste_Special Values

Good Luck
Mark Graesse
(e-mail address removed)

----- Lynda Hillborg wrote: ----

I want to change all text in a worksheet to upper case. I
found the formula to use =upper(), but don't know where to
enter it. If I put it in the cell to be changed to upper
case it shows as a circular formula

Any easier way to revise entier worksheet
 
Back
Top