Macro-Replace on keywords from cell1 to cell2

[Closed]
Report
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
Hello,

I have a situation where I have to replace the data appearing in Cell1 in Cell2 for specific words.

For example if I have a business or an individual's name in Cell1 and in cell2 there are certain words such as We, they, us, our, our's, their etc should be changed to the contents of cell1.

Below is an illustrated example for the above request.

Input:
Cell a1 ABC Consultants
Cell a2 ABC Consultants provide services related to Banking, Finance, Insurance, Claim related consultancies. They also have a 24/7 help line availble for their customers.

Output:
Cell a2 ABC Consultants provide services related to Banking, Finance, Insurance, Claim related consultancies. ABC Contantants also have a 24/7 help line availble for their customers.

The help and assistance on the above request would be highly appreciated.

Thank you and best Regards - AJ


1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi AD,

Does this look like a solution to you?:

A2:
="ABC Consultants provide services related to Banking, Finance, Insurance, Claim related consultancies. "&A1&" also have a 24/7 help line availble for their customers."

Best regards,
Trowa