Forum Discussion
Formatting of strings of letters/numbers
Hi, I'm hoping someone can help me, I have reports that come through daily with identification numbers that contain a mix of letters and numbers, and I need to format them with dashes to be able to i...
With such a text value in A2, enter the following formula in B2, then fill down:
=TEXTJOIN("-", TRUE, LEFT(A2, 3), MID(A2, 4, 3), MID(A2, 7, 4), MID(A2, 11, 100))
