Separate a Look Up field (separated by commas) into separate cells

[Vincent_Weselak]

I would like to separate a look up field (values separated by commas) into separate cells.

I have information from Table 1 linked to Table 2 (Junction Table) that is linked to Table 3.

Table 3 has a look up field (puling information form Table 1 to Table 2 into Table 3). The values in the look up field are separated by commas. (I am having a problems applying formulas to the look up field).

Is it possible to separate these values into separate fields?

[kuovonne]

Partnerships_Team:

except when separating emojis.

Not sure although it might have to do with emoji actually being composed of multiple characters.
However, I still think a scripting option is now better than a formula.

[shmuelpalgon]

This "concatenating" hack wont work if there are multiple matches in the lookup field. 

See what happens below:

 

As you see, the IDs are combined. I need them to remain split either by comma or anything else unique so that I can separate ID's into different fields as you outline above. 

 

 Do you have any possible suggestions here?

[shmuelpalgon]

@kuovonne 

[MarioD]

Have you found a way to deal with this yet?  I  just run into this and I could not figure out what the issue was until I found your comment.