I have this Excel cell A2
with the contents USD.EUR[IDEALPRO,CASH,EUR]
.
I would like to extract the substring EUR
from the last part of the string using an Excel formula. The nearest formula I came out with is =RIGHT(A2,4)
. However, it returns EUR]
.
What formula can be used to extract the substring?
I am using MS Excel 2013.
See Question&Answers more detail:os