How to extract multiple instances of a keyword from a cell?

I wanna extract anyt text in a call that starts with LQ1 to a length of 10 characters to an empty cell, coma delimited. Is this possible?

using search you can find the location (in characters in from the start) of the text LQ1

eg text is applesLQ1pearsplumsoranges

the search returns 7

LEN(cellref) returns 26

MID(cellref,7,10) returns LQ1pearspl

Thanks rob, but this does not handle multiple instances of LQ1 in the text. So if I have text like applesLQ1pearsplumsoranges peacheslq1iloveanddig'em, I would like to get'em as LQ1pearspl, lq1ilovean

applesLQ1pearsplumsorangespeacheslq1iloveanddig'em

search to find the first example of LQ1 (at character 7)


in a temporary helper cell insert the formula

=mid(textcellref,search(textcellref,"LQ1")+10,200)

in here you will see umsorangespeacheslq1iloveanddig'em

now do the search on this cell

you can have as many tries as you like, you will get error messages where only one instance of LQ1, but you can trap these out using ISERROR

A better example

FRN EMTN 08/2007 CAD10000'B1339' 4.472 08/20/2007
Issuer: Abbey National Treasury Services plc (LSE:57AY) (IQT32033759)
08/20/2007

FLTG RATE NTS 8/2007 JPY100000000 4.333 08/21/2007
Issuer: Abbey National Treasury Services plc (LSE:57AY) (IQT31942187)
08/21/2007

FR GTD EMTN 22/08/2007 GBP100000 'B1340' 5.758 08/22/2007
Issuer: Abbey National Treasury Services plc (LSE:57AY) (IQT32037171)
08/22/2007

I need to put in the formula in a single cell to get the coma delimited list of the IQT id's

Nope. Only gave me the first instance. - IQT32033759