Hi,
Can anyone help...
I have an excel spread sheet with over 7000 rows of data on (only 3 columns).
For some reason, some 3500 of the key cells have a double space prior to the character which in turn is affecting the a-z sorting of the data. Excel is assuming that the double spcase is a character and sorting them differently to the rest of the sheet.
Without manually going through the 3500 cells and deleting the double space, does anyone know how I can remove the double space before the characters so that it sorts correctly?
(I've tried left and right align but it doesn't change the way it sorts...)
Many thanks for any help you can give me.
Bookmarks