Forum Discussion
Solved
I need Excel Help
In my sheet, cell B2 has the following string "ABCDEF-A012340WABCD-0101" and cell C2 has a value of 3. I need a formula that outputs 3 separate lines in cell D2. Each line should be separated by 'alt...
In D2:
=TEXTJOIN(CHAR(10), TRUE, LEFT(B2, LEN(B2)-4)&TEXT(SEQUENCE(C2, , --RIGHT(B2, 4)), "0000"))
Turn on 'Wrap Text' for D2.
Fill down.
In D2:
=TEXTJOIN(CHAR(10), TRUE, LEFT(B2, LEN(B2)-4)&TEXT(SEQUENCE(C2, , --RIGHT(B2, 4)), "0000"))
Turn on 'Wrap Text' for D2.
Fill down.
- Thank you soo much Hans, that worked like a charm. I have spent at least 2 days trying to figure this out. Thanks again.
