Thread: Pick up some text in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
  
Posts: 173
Default Pick up some text in a cell
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

Reply With QuoteReply With Quote