In reference to this:
I have a string: "=SUM(B1+C1+D1)"
In the previous question I asked how to increase by 1 all the numbers to get B2+c2+D2 in the string... Thanks Kaufmed..
now I need to inscrease the letter... lets say I have X = 2
I would need to do: index of B (wich would be 2 in alphabet) + 2 equals 4
I would get: D1, E1 and F1
if string is: "=SUM(A5+B5+C5)" and my X varialbe is 6
I would have: "=SUM(G5 + H5 + I5)"
Can you help ?