Thread: [Solved] Cannot Convert Text Cell to number format to be able to sort the data
View Single Post
 
Old 06-18-2013, 09:20 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 excelledsoftware View Post
Ok I am not entirely why but it appears that the spaces in your original distance are actually char characters and not spaces. I have attached the corrected values. Instead of placing a space in the formula I copy and pasted a space from your distance values. It may be Char 255 or 256 again not sure. Using the attached will sort.

Let me know if you have any other questions.

The last thing on the char character may be if you copy and pasted the distance values from somewhere or imported them. In any case the substitute formula is working with the space copied and pasted.
Reply With Quote