Lower Function

[Guest]

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

 

[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.

 

[Guest]

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

 

[Frank Kabel]

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

 

[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. ***