Inserting text in front of digits in a string that has delimiters

I need to insert text from a specific column in front of digits in another column, which is a string of digits with semi-colons as delimiters.

I've included a sample file to make it easier to follow.

Column A and B will always be text, and if it matters the length of those characters will vary between 2 and 6.

Column C and D will always be two-digit numbers separated by semi-colons. The sets of delimited numbers will always be 2-digits between delimiters. The amount of delimited sets of numbers will vary between none at all to a maximum of 13 in each column.

What I need to get in column E is the text from column A in front of each number in column C, with a space between the text and number. I've typed what that result should look like in column H.

Then use that same process for column F where the text from column B is in front of each number in column D. I've typed what that result should look like in column I.

Try:

=IFERROR(MAP(A2:A17,C2:C17,LAMBDA(x,y,TEXTJOIN(";",,DROP(x&TEXTSPLIT(y,";"),,-1))))&";","")

copied ACROSS only.

And the other solutions offered??

Easily fixed, FWIW:

=IFERROR(MAP(A2:A17,C2:C17,LAMBDA(x,y,TEXTJOIN(";",,DROP(x&" "&TEXTSPLIT(y,";"),,-1))))&";","")

Do take the time to respond to ALL who helped. It is basic courtesy.



You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.