Sorting order - text and numbers



I have an inventory sheet where items are listed as: BE-01, BE-02..., PE-01,
PE-02... etc. When I add new items I indicate a preliminary inventory as
(ie) BE- in the inventory number column. When I am done I may have several
items that have BE- in the inventory number column. When I sort the
worksheet, all the BE- items end up together, but they sort before BE-01,
BE-02... I want them to sort at the end of the BE group so I can assign an
inventory number by dragging the cursor to continue the series. How can I do

David McRitchie

Why not let them just sort to where they will as you will have to sort them
again afterwards.

Use Conditional Formatting to Identify the incomplete ones.
I think you could use a formula like


More on Conditional Formatting on

another possibility would be to use Filter


Instead of labeling new entries
Try using

That'll sure put them at the, wouldn't it ?

And of course, dragging down at least the last 2 old entries will overwrite
the 9999.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question