Pick up some text in a cell
=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
|