Help

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

Solved
Jump to Solution
3886 0
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?

33 Replies 33

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.