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.

Why not use Excel's built-in Sort feature on the row[s]?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion