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