software

I have a column for comments
there are 900 rows (A1:A900)

this data is being imported from another source and some users have
extra spaces that I want to remove and place in (B1:B900)...I also want
to format it so that it is converted from all caps to all lowercase.

For example:

A1 reads quot;INT IN A FREE QUOTE ON 50000 CASH FOR DEBT
CONSOLIDATIONquot;

B2 reads quot;int in a free quote on 50000 cash for debt consolidationquot;--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=502511
B1=trim(lower(a1))--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=502511
In cells B1:B900, put the following formula:-

=TRIM(LOWER(A1))--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=502511In cell B1, use the formula =LOWER(A1) to convert the value of A1 to
all lower case. Copy that formula down thru B900. Then copy column B,
and gt;Paste Special as gt;Values onto column B, converting the formulas to
text. Highlight column B; search for quot; quot; (two spaces, but don't use
the quotes) and replace with quot; quot; (a single space, no quotes). Repeat
the search and replace until you get the quot;can't find anything to
replacequot; message.