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.

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)

"shaji" wrote in message
...
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.

Thanks Bob

"Bob Phillips" wrote:

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)

"shaji" wrote in message
...
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.