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

C

Challenged

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?
 
M

Marcelo

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:
 
M

Marcelo

or

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



"Challenged" escreveu:
 
Top