Replace or Substitute for COMBIN function
I have lots of lines in this format to convert into COMBIN function
(39c3 - 37c3)
In the above line I want to convert it to ((COMBIN(39,3)-(COMBIN(37,3))
I have so many lines in the above format. All I want to change the c to
COMBIN with values intact as I have give the example.
Some of the lines are in this format.
(45c6 / (6c5 x (39c1 - 37c1)))
The above line should become
((COMBIN(45,6))/((COMBIN(6,5)*((COMBIN(39,1)-((COMBIN(37,1))))))))
Thanks in advance.
|