**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.*