Quote:
Originally Posted by jyfuller
I think you forgot to upload the file you changed with spaces; there is no new spaces and I can't sort. It looks the same to me as the others I posted, nothing is changed. Can you give more detail in the post or in the excel file to explain what you are doing exactly to get rid of the spaces and also how to tell if there are spaces in the cell (character numbers make no sense to me)?
|
I will get that information to you later if needed. When I tested it, I copy and special pasted all the values after the substitute formula. This allowed me to sort it. You probably may need to do the same. If pasting special is not an option we will figure something out.
Let me know if you still need me to re-upload or not.
Thanks
06-18-2013, 10:59 PM
Similar Threads
Sort Data
Windows 7 64bit 
Office 2003
Threaded Mode