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.