Lower Function

H

Harvey

I'm trying to covert text in a column from proper case to all lower case and
can't get the format of the command properly. If I want the function to
affect the entire column where do I type the command?

Thanks for your help.

Harvey
 
M

Myrna Larson

It isn't a command. It's a worksheet function. If it's column B to be
converted, you must put the formula =LOWER(B1) in another column (I'd insert a
new column C and put the formula there) and copy down as far as needed. Then
Edit/Copy the column of formulas, then, without changing the selection,
Edit/Paste Special and select the Values option. Now you can delete the
original column with the proper case text.
 
H

Harvey

Myrna - thank you very much. I'm about 1/2 way there. You can see that I'm a
complete novice with this. I created the formulas in column C as suggested,
copied and pasted them all the way down and the text did successfully convert
to lower case. Yet when I deleted the column B all of column reverted to the
following: =lower(REF##). What did I do wrong.

Thank you for putting up with me.

Harvey
 
F

Frank Kabel

Hi
before deleting column B try the following:
- select column C
- copy this data
insert it with 'Edit - Paste Special - Values'
 
M

Myrna Larson

You didn't do what I told you <g>. You didn't convert the formulas to their
values via Paste Special:

"copy [the formula] down as far as needed. Then *** Edit/Copy the column of
formulas, then, without changing the selection, Edit/Paste Special and select
the Values option. ***
 
Top