Thread: [Solved] Cannot Convert Text Cell to number format to be able to sort the data
View Single Post
 
Old 06-18-2013, 10:59 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
  
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default
Quote:
Originally Posted by jyfuller View Post
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
Reply With Quote