Extract string from cell

[ukguy]

Hello,

I'm trying to extract the following value 'this is what I want to extract' from the below.

m-1006621-cid:122244-kid:kwd-weweqe-KW:this is what i want to extract-e--04/08/2020 12:20:53
m-1006621-cid:122244-kid:kwd-weweqe-KW:this is what i want to extract-b--04/08/2020 12:20:53

I've used the following which works (using 2 formulas) but ideally want it in one:

=IFERROR(MID(A1,FIND("KW:",A1)+3,LEN(A1)),"")
=IFERROR(LEFT(A1,FIND("-",A1)-1),"")

[Pepe Le Mokko]

Can you please add some more examples to see if all patterns are the same / different? ( see yellow banner)

[ukguy]

Forgot to press upload. See attached!

Is it possible to also extract the cid and kwd value as well.

[oeldere]

with text to column and used - as seperator.

see the attached file.

[ukguy]

Thanks - really need this in a formula as the source data will be changing daily.

[Bo_Ry]

Please try at A2

=TRIM(LEFT(SUBSTITUTE(MID(D2,IFERROR(SEARCH("KW:",D2),8)+3,99),"-",REPT(" ",99)),99))

or

=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(D2,IFERROR(SEARCH("KW:",D2),8)+3,99),"+",),"--",),"-",REPT(" ",99)),99))

[bebo021999]

It is quite long, but it works without helper:

Please Login or Register  to view this content.

[ukguy]

Thanks for your help.

Unfortunately they didn't work.

The following got close but didn't extract any strings that contained +this is a value I want to extract

=TRIM(LEFT(SUBSTITUTE(MID(D2,IFERROR(SEARCH("KW:",D2),8)+3,99),"-",REPT(" ",99)),99))

[oeldere]

@ukguy

You got 3 possible answers to solve your problem.

You tell us 1 doesn't work.

What about the other 2 solutions?