Help

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

Topic Labels: Formulas
Solved
Jump to Solution
23410 35
cancel
Showing results for 
Search instead for 
Did you mean: 
Vincent_Weselak
4 - Data Explorer
4 - Data Explorer

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?

35 Replies 35

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.

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

See what happens below:

Screenshot 2023-02-06 at 3.35.13 PM.png

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

YOUNGKINGTZ
4 - Data Explorer
4 - Data Explorer

I need youtube ID

youngkingtzyoungkingtz