Hi. I would like a formula
I have 2 rows of cells A&B. A contains a long number and B a reference.
Eg. If the cell in B4 says "ALL" I would like to replace the last 4 digits in A4 with "1234" If B4 is blank then it leaves A4 as it is.
Thanks in adavance.
I have 2 rows of cells A&B. A contains a long number and B a reference.
Eg. If the cell in B4 says "ALL" I would like to replace the last 4 digits in A4 with "1234" If B4 is blank then it leaves A4 as it is.
Thanks in adavance.