Change sort

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a spreadsheet with a column I need to sort by. This
column has some numbers and some alpha-numeric. Of course
right now it sorts: 1234, 2468, 1234-0000,2468-0000 is
there any way to get 1234 in the same "group" as 1234-
0000? Thanks for your assistance.

Mike
 
use a helper column and sort by that.

If your data is in column A, then maybe:

=""&A1

Will work for you.
Numbers will become text in the helper column. And it won't hurt any text
already there.
 
Back
Top