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 "INT IN A FREE QUOTE ON 50000 CASH FOR DEBT
CONSOLIDATION"

B2 reads "int in a free quote on 50000 cash for debt consolidation"


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=502511