I have a column of names and would like to do a data conversion
from lower case to upper case. I know the formula is =upper(" ")
but is there a way to have it do the conversion for an entire column at once.
Don't know what I am doing wrong but it seems I have to enter it in each
cell which is not exactly a time saver......

Any suggestions? Thanks.

Alicia

Insert a column directly to the right of the original column.

Then type
=upper(a1)
(adjust the cell's address)
then fill the rest of the cells using the techniques at Debra Dalgleish's site:
http://contextures.com/xlDataEntry01.html#Mouse

After you do that, you can select the new column
edit|copy
edit|paste special|values
and delete the original column

Alicia wrote:

I have a column of names and would like to do a data conversion
from lower case to upper case. I know the formula is =upper(" ")
but is there a way to have it do the conversion for an entire column at once.
Don't know what I am doing wrong but it seems I have to enter it in each
cell which is not exactly a time saver......

Any suggestions? Thanks.

Alicia

--

Dave Peterson

Just enter first cell and copy down.

in B1

=UPPER(A1)

Copy/drag down as required.

Copy, Paste Special =Values to remove formulas from Column B

"Alicia" wrote:

I have a column of names and would like to do a data conversion
from lower case to upper case. I know the formula is =upper(" ")
but is there a way to have it do the conversion for an entire column at once.
Don't know what I am doing wrong but it seems I have to enter it in each
cell which is not exactly a time saver......

Any suggestions? Thanks.

Alicia