Can there be way or macro be written where search is made to the whole sheet and whereever the following left contents are found they are get replaced by the right hand side contents.
DK, R Dinesh Kumar, Rakesh
R, KD Rakesh, Kumar Dinesh
A,B,C,D&E Apple,Ball,Cat, Dog & Egg
A78GHj North America
There are almost 100 codes which I need to replace.
Please note above DK, R are two codes as they are separated by comma so they will be replaced by Dinesh Kumar, Rakesh
similarly A78GHj,A78GHj will get repalced by North America, North America