On 12/12/2017 at 11:05:12 PM GS wrote:

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

Because (I think) I would have to sort each row individually. That
would take forever.

Each row has bin numbers for a different part number, so I would have
to sort Row 1 by itself, then sort Row 2 by itself, etc. etc.

Am I perhaps missing something?

In the Sort dialog Options/Orientation, choose Left to Right!

--
Garry

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