This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 T...
Thanks for the reply. I found a similar formula used for excel that worked utilizing SUBSTITUTION function and MID function.
MID({Field1},FIND(“CHAR(1)”,SUBSTITUTE({Field 1},",",“CHAR(1)”,1))+2,FIND(“CHAR(2)”,SUBSTITUTE(Field 1},",",“CHAR(2)”,2))-2-F...
