| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
