I have an excel spreadsheet with part numbers in Column A and bin
locations in Cols. B to G. I would like to find a formula that sorts
the bin locations in Cols. B-G alphabetically. The bin locations are
formatted as Text.

For instance, Cols B1 to G1 show:
22-2D 49-6A 48-1A 49-1C 49-5A

I would like to have a formula in Cols. H1 to O1 that sorts like this:
22-2D 48-1A 49-1C 49-5A 49-6A

Can anybody help me? Thanks.

--
tb