Hi,

Monthly I have to convert comments from a local currency sheet to a US
dollar sheet in an excel file. In the comments the local currency is
often expressed. I need the value to be in US dollars when it appears
on the US dollar sheet. Is there a way to search the text to find the
local currency amounts and use a variable to convert that to US dollars.

Thanks in advance for any help that you can provide. I'm not betting
that I will get many answers to this one . . .

Regards,
Anita