formula to add a number to a long string **
=LEFT(A4,10)&--RIGHT(A4,3)+B4
Where 24.43.234.555 is in A4 and 23 is in B4.
HTH
Regards,
Howard
"MMangen" wrote in message
...
I'm not quite sure how to best describe this:
I need a formula that will take the example below and return the "final
result"
Col. A = 24.43.234.555 and Col B= 23 making Final Result = 24.43.234.578
Is there a way to do this?
|