View Single Post
 
Old 09-06-2012, 04:40 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Data Sorting

Hi
Your issue may be something to do with where you got your data from.
You may have "white spaces" at the beginning of your fields etc.
Try copying your data into a Word table first and turn on the "Show/Hide" button. This will show you whether you have strange characters wrapped around your data, which you can then remove before copying it back to Excel.
Hope this helps.
If not and you can post a sample I will take a look for you and advise further.
Good luck.
Tony
Reply With Quote