Extract Specific Text From Cell

Copper Contributor

Hello,

 

I'm trying to extract specific text from cells that have lots of text in them separated by commas. 

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. 

 

katietrev27_0-1702423332898.png

 

 

 

Any help would be great,

 

Thank you, 

 

 

2 Replies

@katietrev27 

 

Try this:

 

=LET(
  r,$C2,
  f,"x-StyleCode:",
  x,MID(r,SEARCH(f,r)+LEN(f),LEN(r)),
  LEFT(x,FIND(",",x)-1)
)
THANK YOU!!!!