Hi:
I work in a company with sales to many customers. At the month end, I am required to review and manually correct the names of customers maintained in an excel file which is a very cumbersome process using the find and replace all option. Is is possible if this process can be automated through a formula or code?. I have attached a sample list showing the original text / character that is to be replaced with the text of my choice. The excel files have just names so I am not attaching it. Hope I have explained my query well. Looking forward to usual help and assistance.
Thanks & Regards
I work in a company with sales to many customers. At the month end, I am required to review and manually correct the names of customers maintained in an excel file which is a very cumbersome process using the find and replace all option. Is is possible if this process can be automated through a formula or code?. I have attached a sample list showing the original text / character that is to be replaced with the text of my choice. The excel files have just names so I am not attaching it. Hope I have explained my query well. Looking forward to usual help and assistance.
Thanks & Regards