Thanks Dave for your response.

Well, the method you provided is what I already tried. That is, if the
addresses were in column A, and in Column B, I reference the column using
=UPPER(A1) and drag down to fill series, then it will work.

What my boss wanted was finding out if there was a way to:

First Do
=UPPER("123 Main Street")

and then using the fill function so that the formula format =UPPER("text")
will be applied to subsequent cells automatically.
=UPPER("1412 south avenue")
=UPPER("592 northern main drive")
=UPPER("243 EAST ROAD")

I thought I could get by with using the reference column, but she wants a
simple way where the average users will know how to do this. Simplest way
would've been a built-in excel function that will change all highlighted cell
contents to either UPPER/LOWER/PROPER case. But I don't think there is that
function, or is there...?


"Dave F" wrote:

Another thing to consider is that if your boss doesn't want to see the
formulas, just copy the column, select paste special--values and click OK.

Dave
--
Brevity is the soul of wit.


"Dave F" wrote:

=UPPER(A1)

Select that, hold the shift and down arrow and release these keys when you
get to the end of your range. Then CTRL+D.

The method you were trying is for data series, i.e., Monday, Tuesday,
Wednesday, etc.

Dave
--
Brevity is the soul of wit.


"Shohoku79" wrote:

Ok, I understand that in Excel, to convert a string of texts to all caps
could be done by using the UPPER formula ( e.g. UPPER("Text") )
My supervisor came to me and asked me, she has a column full of street
addresses in mixed cases that she needs to convert to all caps.

Example:
123 Main Street
1412 south avenue
592 northern main drive
243 EAST ROAD

I tried the UPPER formula on the first one and wanted to do the same for all
the others, but the Fill series / paste special all seemed to end up copying
the contents of the first cell rather than repeating the =UPPER("text") for
the series. Then I thought about doing this by reference. So I copie
generated a seperate column and used the reference formula (=UPPER(A1)) and
filled series, this worked. But my boss complained and said this is too
complicated and insisted that there is an easier way.

My question now is, is there any way to do this without having to use
reference?

Thanks a bunch.