Hello,

I building a data mapping/translation function and need help on how to easily to this. I tried searching prior posts but can't seem to find the correct search criteria.

In a Excel worksheet I have 500 or more cells with info on how to transform the data.

For example:
cell A1 contains: "Hello " & a

in VBA "a" is a variable that can contain "World", for example. So I expect the result to be "Hello world"

cell A2 contains: "My height is " & a/b & " feet."

in VBA a = 72 and b = 12 so result will be "My height is 6 feet."

I've tried Evaluate but doesn't like variables. Is there a easier way to find and substitute variables? I don't mind changing the mapping syntax in the cells to make this easier.

Thanks for helping.