TEXT String MID Help needed

[seenfresh]

I have a situation where I would like to be able to extract a certain number of characters in a given string... for example:

Joe Joe KLTV 300x600
Joe KLTV 728x90 Leader

From the two examples I would like to be able to just extract the "KLTV" Upper Case call letters...

I'm assuming code must be involved... Is their a way to pull the text of a string where the succeeding text is Upper Case...?

It doesn't seem possible to me due to the variation in location of the call letter I need, but Any Suggestions would be Awesome!!!

Thanks in advance,

 

[RalphA]

If all call-letter groups start with a K, it would be simple to use, assuming the data is in B2:
=MID(B2,FIND("K",B2,1),4)

 

[tusharm]

If you have the regular expression functions at http://www.tmehta.com/regexp/add_code.htm you can then use
=RegExpFind(B3,"[A-Z]{2,}")
where B3 contains the text to be searched.

I have a situation where I would like to be able to extract a certain number of characters in a given string... for example:

Joe Joe KLTV 300x600
Joe KLTV 728x90 Leader

From the two examples I would like to be able to just extract the "KLTV" Upper Case call letters...

I'm assuming code must be involved... Is their a way to pull the text of a string where the succeeding text is Upper Case...?

It doesn't seem possible to me due to the variation in location of the call letter I need, but Any Suggestions would be Awesome!!!

Thanks in advance,