Extract Specific Text From Cell

Question

Hello,&nbsp;I'm trying to extract specific text from cells that have lots of text in them separated by commas.&nbsp;In the attached example, I want to find the x-styleCode: for each ID, and am hoping I can do this by using a formula in column D that will extract only the x-styleCode values.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Any help would be great,&nbsp;Thank you,&nbsp;&nbsp;&nbsp;

flexyourdata · Answer

katietrev27&nbsp;&nbsp;Try this:&nbsp;=LET(
  r,$C2,
  f,"x-StyleCode:",
  x,MID(r,SEARCH(f,r)+LEN(f),LEN(r)),
  LEFT(x,FIND(",",x)-1)
)

katietrev27 · Answer

THANK YOU!!!!

Forum Discussion

Extract Specific Text From Cell

Share

Resources