Question description:
This user has given permission to use the problem statement for this
blog.
To write an Excel formula for the TRX column
-by extracting the other currency in the Currency Pair in column A
Solved by V. J. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/08/2017 - 11:06
Hi, It's pleasure to help you today:)
Excelchat Expert
23/08/2017 - 11:06
Explanation phase:
User
23/08/2017 - 11:06
Hope this makes sense
Excelchat Expert
23/08/2017 - 11:07
Yes
Excelchat Expert
23/08/2017 - 11:07
I am working on
User
23/08/2017 - 11:07
cool thanks
Excelchat Expert
23/08/2017 - 11:09
=mid(A2,find(B2,A2,1)-4,3)
Excelchat Expert
23/08/2017 - 11:09
Discussion phase:
Excelchat Expert
23/08/2017 - 11:09
Please test it
User
23/08/2017 - 11:09
Can you explain how excel can recognise the currency in the currency pair
Excelchat Expert
23/08/2017 - 11:10
I am using find function to check the presence of currenc
User
23/08/2017 - 11:10
Doesn't seem to work for the 3rd row
Excelchat Expert
23/08/2017 - 11:11
GBP was not there in column B
User
23/08/2017 - 11:11
yes sorry my bad!
User
23/08/2017 - 11:11
Can you break the explanation down
Excelchat Expert
23/08/2017 - 11:12
Ok. Do you have any further questions. Please use EX_Ch expert code in upcoming sessions]
Excelchat Expert
23/08/2017 - 11:12
find will find the position
Excelchat Expert
23/08/2017 - 11:12
and the start position is negative offset of 4
Excelchat Expert
23/08/2017 - 11:12
and i need 3 letters from there
Excelchat Expert
23/08/2017 - 11:13
i am using mid function to get the required
User
23/08/2017 - 11:13
oh genius! thanks
User
23/08/2017 - 11:14
if it was GBP/AUD, will it work>
Excelchat Expert
23/08/2017 - 11:14
You are welcome:)
Excelchat Expert
23/08/2017 - 11:14
No
Excelchat Expert
23/08/2017 - 11:14
GBP should be on the right side
User
23/08/2017 - 11:14
`Oh yes, I have to modify the position
Excelchat Expert
23/08/2017 - 11:15
Hope, you have further questions in queue?
User
23/08/2017 - 11:15
can you tell me how to modify if GBP is the 1st currency?
Excelchat Expert
23/08/2017 - 11:15
then it should be +4
User
23/08/2017 - 11:16
hah, understood, thanks
User
23/08/2017 - 11:16
can I have a link to this file?
Excelchat Expert
23/08/2017 - 11:16
ok. Great
Excelchat Expert
23/08/2017 - 11:17
https://docs.google.com/accounts?authuser=1&continueUrl=https://docs.google.com/spreadsheets/u/1/d/1v1cMwY2tCTUyq6rciQy6BmNE9PnoeXmBxpK5LATdcDM/edit
User
23/08/2017 - 11:17
thanks!!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.