Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
Create a helper column with the following formula:
=SUBSTITUTE(A1,"-","") Then sort by this column. -- Regards, Dave "Challenged" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|