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.
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 ).