SORTING TEXT AND NUMBERS
thanks, that did it
"Elkar" wrote:
If you don't need the asterisks, then just do a Find/Replace.
Find: ~*
Leave the Replace With Field blank
If you need to keep the asterisks, then I'd suggest adding an additional
column and using the following formula:
=SUBSTITUTE(A1,"*","")
Then sort by this new column.
HTH,
Elkar
"jstephenson" wrote:
i am trying to sort a non sequential list of numbers mixed with numbers
marked with an asterisk in front, such as on a bank statement of checks:
1224
1222
*1223
1221
1227
*1225
1228
and so on. When I sort, all of the numbers with an asterisk are grouped
together. I formatted them as text with the same result. Is there anything
i can do?
|