You're welcome. Thanks for the feedback


"OfficeNDN" wrote in message
...


"Trevor Shuttleworth" wrote:

Add a "Helper Column" and put the following formula in row 2 and drag
down

=IF(LEN(A2)6,--RIGHT(A2,6),A2)

which assumes your receipt number is in column A and starts in row 2

Now sort on the Helper Column

Regards

Trevor


Thank you!!! That was exactly what I was hoping for!!!