Looking for a formula to paste cells without override.

[hani85]

Hi gurus. am looking for a formula to paste value without overriding another value. For example in my case, I want to replace the value in G column (highlighted in red) by the value from J column (cells that on the same row as the values highlighted in red). For those values in B column that originally start with M180, i want it to be untouched. Right now I dont know what formula should i use.

U can see the attachment for reference. Tq

[sktneer]

You can not place a value and a formula in the same cell. Rather you can place the formula in another column (say H).
There are several ways to achieve this and one of this is as below. Try this in H2

Please Login or Register  to view this content.

and drag down.

[AlKey]

You can try this

in K2 use formula

=IF(J2="",G2,SUBSTITUTE(G2,G2,J2))

and copy it down then copy all values in column K and Paste Special back in column G Values only.

[sktneer]

Alkey's formula is much better because you said that you want to replace the value from the same row and I forgot that point.

[hani85]

Thanks Alkey and sktneer. its working. now i understood the IF function