Code for Trim function

[shaji]

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)

"shaji" <shaji@discussions.microsoft.com> wrote in message
news:0C0773E2-F11A-4BD5-9C53-225D6EA598CE@microsoft.com...
> 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.
>
>

[shaji]

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" <shaji@discussions.microsoft.com> wrote in message
> news:0C0773E2-F11A-4BD5-9C53-225D6EA598CE@microsoft.com...
> > 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.
> >
> >
>
>
>