Removing Extra Spaces

[sharon.dawson]

I have done an export from SAGE and when imported into Excel it has added 3,4 or 5 spaces to the end of each product number. Is there an easy way in which i can strip all of the spaces at the end of the product number only.

Regards

 

[GlennUK]

In an empty column use a formula like this:

=TRIM(A1)

and copy down as required ( adjust the formula ref to suit your case ). Then copy the results, and do a Paste Special/Values over the originals. Delete the column of formulae that you created ( they are no longer needed ).

 

[sharon.dawson]

Thanks Glenn, worked a treat!!

 

[GlennUK]

My pleasure