I'm using Excel 97 (at home and at work), and need to know how to simply remove leading spaces from columns of text imported from other sources, such as Word.
The TRIM function only appears to work if you know what the following text is. As I'm dealing in 1,000s of given names at a time, with only so many duplicates, this is not practical.
Is there any way to do this, or to combine the TRIM and the LEFT function, so it only removes the 1st character on the left of the column? (And the RIGHT function to remove trailing spaces?)
I've dealt with it for a long time now by dumping the data into Word, converting the resulting table into text, replacing the paragraph mark &" " with a paragraph only, converting the text back into a table, and dumping it back into Excel.
This works fine, takes only a few steps and is easy to do. It is just very resource hungry when the list is long (most of mine are over 2,000 names long), and my time could be better spent massaging the data I've acquired!
Looking forward to learning a much more efficient way of doing this, and any help/suggestions are very welcome,
H in Melbourne, Vic