Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a database and need to subtotal by a column that has no set number of
characters, some with "-" and a letter after, some just whole numbers. I
want to sort by the whole number and ignore the "-". Ideas?
 
Hi Challenged,

on an auxiliar column use this formula (assuming that the list are in column
D)

=if(iserror(find("-",d7)),d7,left(d7,find("-",d7,1)-1)&right(d7,len(d7)-find("-",d7)))
sort by this column

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Challenged" escreveu:
 
or

=substitute(d7,"-","")
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Challenged" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List 6-of-36 combinations matching 4 (errata) 1
Need to Sort #'s in Column B,C&D in the order from Column A 3
How do I sort addresses in excel? 4
With F1 value, look at A, if match or partial match return B 5
Challenge for Anyone to take it on. 4
SORT A LIST OF NUMBERS AND LETTERS A,B,C,D AND FIND MAX 2
Sorting Macro 4
Sorting on only certain characters in a cell 3

Back
Top