If your required data is in column G, then you would need to use a new
column (perhaps insert a new column H and push the other columns
over),
then in H1 put
=trim(G1)
and click on cell H1 and drag the small plus sign in the bottom right
corner of the highlight down the column for as many rows as you have
data in the G column.

This would then give a 'trimmed' column H for you to use.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390428