Need a method to convert varying french words to english within a cell

H

hollerg

I have a spreadsheet with descriptive terms in French. I would like a
search and replace method that can replace multiple the target words
within a cell, when that cell contains additional words and names that
are not to be altered.

How do I do this with substitute and a vlookup from a table of target
words and english equivalents or is there a VBA macro that will do
this?

Thank you for your time and any help you can give.

Regards
G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top