View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Pick up some text in a cell

Your formula returns incorrect value with this example

EUR/JPY SHORT EUR 20000 MIO

=MID(A1,FIND("MIO",A1)-3,3)



"Glenn" wrote:

=MID(A1,FIND("MIO",A1)-3,3)

Elton Law wrote:
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