Forum Discussion
Extract Specific Text From Cell
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 c...
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!!!!
