letters and numbers

  1. D

    Enter specific formulated data - numbers & letters with dashes

    I am working on a shared spreadsheet for tracking and I need users to ONLY be able to enter a value that is LLNNNNN-NN (letters and numbers) and in another column (different data) LNNNNNNN-NN. Both are combos of letters and numbers but I need users to only be able to enter it in these ways. For...
    • dillpickle
    • Thread
    • data validation excel formatting formula letters and numbers
    • Replies: 2
    • Forum: Excel Questions
  2. J

    Sorting through Shelf Marks

    So I have an excel spreadsheet that I need to order in Shelf-Mark order. The Shelf-Mark is a thing with a mixture of numbers and letters, and completely variable lengths. For instance DVD WB365 MEB, QZ210 DIA, and OP121.96 and Excel doesn't like it very much. I've heard that the easiest way to...
    • Jjarma
    • Thread
    • letters and numbers mid seperating shelf-marks sorting
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top