In the cells you want to check for even set the data validation to custom, then in the formula
=NOT(MOD(A2,2))
check odd numbers in the same way with the formula
=MOD(A3,2)
of course adjusting the cell address, the style, and Error Alert you want in response
Alphabetical order: Numeric, Alphanumeric, Alpha.
1,
2,
3,
4,
5,
10,
2a,
3Regy,
4a,
6Alpha,
Alpha,
If you prefer 2a to follow 2, then you need to add a space. Adding a space signifies a second grouping. Hyphenated names (words) are last.
1,
10,
2,
2 a,
2-a,
3,
3Regy,
4,
4a,
5,
6Alpha,
Alpha
Further:
5 Alpha,
5Alpha,
5-Alpha,
6 Alpha,
6Alpha,
Alpha,
Alpha 6,
Alpha5,
Alpha6,
Alpha-6,
Or use a Zero for place holder: 01, 02, 02a, 10
Or keep the length uniform: 001, 002, 02a, 030
Best Answer
I'm not sure what you mean by "keeping the data in one cell".
A formula requires putting the formula in a different cell. For example:
will place a
space
before the first digit. The TRIM wrapper is in case there already is aspace
.If you need to have it happen within the cell, you will need a VBA Macro as a formula cannot alter the contents of a different cell.