I am having problem with replacing a particular value in excel.
In excel- Column4 contains (hp,hp,hp,dell,dell,dell,nokia,sony,sony)
I need to replace a particular cell value. for e.g. I need to replace the sony with ericsson.
I am using for each loop and if condition to extract the data.
how can I achieve this. can anyone help in this ?