Excel Question

CLAWS · 10 Mar 2006 at 10:38

Very quick question.

I have a column in Excel containing 400 cells of text in upper case.

Is there a way to change all the text from upper case to lower case instead of retyping all 400 cells of text?

TIA

Borris · 10 Mar 2006 at 10:43

CLAWS said:
...

Code:

=UPPER(A1)

F1 is your friend.

Still.

The Office help function, as I said last time, is very good for this sort of thing.

CLAWS · 10 Mar 2006 at 10:50

Sorted!!!

Cheers Borris!