SUBSTITUTE with VLOOKUP for text replacement

[Pedroman]

Hi All

I am sure this is possible, so hopefully you can help

I am trying to translate UK English To US English for a program that uses Excel for content translations

1 sheet has all my content in cells (sentences)
Another I have a column "A" UK words and "B" US Words

I need a formula please that sees a UK word in a cell (could be more than one) and replaces it with the US equivalent

E.g.

The fertiliser was used on the centre field = The fertilizer was used on the center field

It seems i want an amalgamation of SUBSTITUTE with VLOOKUP. Basically it is Find/Replace but for allot of words (500+)

Any ideas please

 

[Macropod]

This is a duplicate of a question you've already asked: SUBSTITUTE with VLOOKUP for text replacement

Please read Mr Excel's policy against Duplicate-Posting in rule 12: Forum Rules

Thread closed. You may continue the discussion in the original thread.