How do change a column of data in capitol letters to small let
Thank you, I will work on it!!!!!!
"Gord Dibben" wrote:
Assuming the column is A
In B1 enter =LOWER(A1)
Double-click on B1 fill handle to copy down.
When happy with results, select column B and copypaste special(in
place)valuesOKEsc
Delete column A
Gord Dibben MS Excel MVP
On Thu, 9 Nov 2006 06:13:01 -0800, Barb P. <Barb
wrote:
Is there a way to highlight a column of data that is in capitol letters and
change to small letters?
|