Hi,
Try this
=1*MID(C11,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C11&"0 123456789")),SEARCH("
",C11,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C11&"012345 6789")))-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C11&"0123456789") ))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Elton Law" wrote in message
...
Hi David,
If this time, I want to capture the 3 letters in front of mio please ?'
EUR/JPY SHORT EUR 20 MIO
AUD/JPY SHORT AUD 1 MIO
USD/JPY SHORT USD 1 MIO
In this case, it should be 20, 1, 1 in each each.
Thanks
Elton
"David Biddulph" wrote:
=MID(A2,FIND("/",A2)+1,3)
--
David Biddulph
"Elton Law" wrote in message
...
Dear Expert,
Want to extract 3 letters after /, in this case, the answer should be
JPY.
EUR/JPY SHORT EUR 20 MIO
AUD/JPY SHORT AUD 1 MIO
USD/JPY SHORT USD 1 MIO
Can ?
Thanks
Elton