Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Regular expressions in Excel?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regular expressions in VB | Excel Discussion (Misc queries) | |||
Substring in excel? How about regular expressions? | Excel Discussion (Misc queries) | |||
Regular expressions in Excel | Excel Discussion (Misc queries) | |||
Regular expressions for replacements in Excel? | Excel Programming | |||
Regular Expressions in VBA & Excel including an interactive tool | Excel Programming |