Cut text after third blank until next blank

[will31]

Hi All,

I have a output from a database where I need to extract the characters after the third blank in the text to the next blank. The string in between varies in length so the formula would need to work like this I think?

Thanks in advance,

Will

 

[T. Valko]

Hi All,

I have a output from a database where I need to extract the characters after the third blank in the text to the next blank. The string in between varies in length so the formula would need to work like this I think?

Thanks in advance,

Will

It would be a good idea if you could post SEVERAL representative samples.

 

[Scott Huish]

=trim(right(substitute(trim(left(a1,find("~",substitute(a1," ","~",4))))," ",rept(" ",255),3),255))