Code for Trim function

[Guest]

I am getting daily sales reports every day. One column contains the ITEMS in
which there are extra spaces. I know that by trim function I can remove the
excess spaces. The problem is I want to insert the formula in each cell
which is very lengthy and there are 350 to 400 records every day. Can anyone
provide a simple vb code to trim the ITEMS column.

 

[Bob Phillips]

Best to look at Dave McRitchie's all-encompassing TRIMALL function
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thanks Bob

Best to look at Dave McRitchie's all-encompassing TRIMALL function
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)