My cell shows USD 2.00
CAN 2.00
EUR 50.00

just want to pick nly the CAN, EUR, USD, e.t.c using vlookup but cant since
it is formatted. I have thousands of rows. Any help totally appreciated. I am
using Excel 2007.

Thanks


"Sheeloo" wrote:

Your cell show $ 2.00 and you want to extract $?

Pl. give an example of what the cell has, what the format is and what you
want to get...

"Yossy" wrote:

I have a column that is cell formatted in currency. I however want to pull
information from the column to another column picking their respective
currecy code but am unable to do that since the format is not showing
Currency. Any help and idea would be appreciated.

I want to use vlookup to pull up information from the coulmn on just the
currency but since currency is formatted I cannot. HELPPPP

Thanks a big bunch.