mattster1010
07-28-2008, 05:11 AM
Hi All,
I have two cells on an excel spreadsheet, one holds a numeric value the other holds a three letter word. I need a formula that will replace the contents of the numerical value if the three letter word cell is not null with the value of the three letter word cell, example below:
Cell 1 = 7 Cell 2 = ABS
Can anyone help?
Cheers,
Mattster
I have two cells on an excel spreadsheet, one holds a numeric value the other holds a three letter word. I need a formula that will replace the contents of the numerical value if the three letter word cell is not null with the value of the three letter word cell, example below:
Cell 1 = 7 Cell 2 = ABS
Can anyone help?
Cheers,
Mattster