A problem with creating a formula to substitute given symbols

Hello!

I've got a workbook with multiple formulas e.g.:

t=S/D

TCh=Ch*(S^2/2D)*(D/Q)

TC=Co*(D/Q)+Ch*((i-D)/2i)*Q

which are built by implementing the symbols:

t, S, D, TCh, Ch, Q, TC, Co, i

I'd like to substitute the symbols in following sequence:

t = a
S = b
D = c
TCh = d
Ch = e
Q = f
TC = g
Co = h
i = x

Questions:

1) Which formula could substitute the symbols automaticly?

2) If there are up to 100 formulas in the workbook in the range of A1:E100,-

would it be possible to to set the substitution for the mentioned range?

See the attachment.

I'll really appreciate your cooperation!

You can not input the formula and the value in the same cell. So if you have values in A1:E100 range, you need to put the substitute formula in a cell which is out of this range. But if you want to change the value in the cell itself, you will need a VBA Code to do that. If this is your requirement, you may try this code to see if this works as per your requirement.

Please Login or Register  to view this content.

Thanks Gak67! Indeed, both formula and Ctrl+H can be used in this case!

Thanks for your effort!

Thank you sktneer! The VBA code you've provided me with is definitely going to be useful!

You're welcome.