Feb 07 2019 05:18 AM
I am recording form numbers in a column, which are very similar and can be sequential but include, one to three random system generated letters:
for example:
3366-011-334J-P
3366-011-337L-C
3366-011-335M-P
The only characters that change are the 10th-15th character of the number. Is there a way to input a wildcard letter character in number formatting?
Feb 07 2019 07:02 AM
SolutionFeb 07 2019 07:02 AM
Solution