Number format with wildcard letters

Occasional Visitor

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:





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? 

1 Reply
Data netered like this in a cell always becomes text and there are no number formats available to format text in a cell. You could use a formula to format a cell entry like 3366011334JP so it shows as 3366-011-334J-P
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies