Sorting with symbols

  • Thread starter Thread starter Turi
  • Start date Start date
T

Turi

I'm trying to sort an excel worksheet by a column that has
various symbols in it, ie $1 and +1. The sort is not
finding a difference between the symbols and intertwining
them, hence, I'm not getting a true sort. Is there a work
around or is this just the way it is?

Thanks!
 
Hi
sounds like these are numbers with different formats. Have you checked
'Format - Cells' and look if they are just formated differently.
 
Turi, are you wanting to sort by $ and + symbols? if so you could try using
a helper column like this and sort on that column =LEFT(A1) and copy down
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
I'm actually sorting by the whole cell. The problem with
that suggestion is that I also have $2, +2, etc. It just
seems that there is no hierarchy of symbols in excel.
 
Yes, they are all text.
-----Original Message-----
Hi
sounds like these are numbers with different formats. Have you checked
'Format - Cells' and look if they are just formated differently.


--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top