SOLVED
Home

Number format with wildcard letters

Manasseh_Jackson
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:

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? 

1 Reply
Solution
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
=LEFT(A2,4)&"-"&MID(A2,5,3)&"-"&MID(A2,8,3)&"-"&MID(A2,11,1)&"-"&RIGHT(A2,1)
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