Replace

[manoj_th]

Hi,

When I copy, paste the names from one file to another, I want the name "John" should replace with "John Vijay" with out using CTRL+H, as the data is large.


I searched in the forum and didn't found the same before posting this.

Please help.
Thanks in advance

 

[Khalid NGO]

Hi Manoj,

Use Find & Replace after copy/paste:

Find what: John
Replace with: John Vijay
Replace all

Regards,

 

[manoj_th]

Hi Manoj,

Use Find & Replace after copy/paste:

Find what: John
Replace with: John Vijay
Replace all

Regards,

Thanks for the reply. I want it without using CTRL+H.

 

[Khalid NGO]

Thanks for the reply. I want it without using CTRL+H.

That wasn't mentioned in your question before i posted.

This will required VBA, I am moving your question to appropriate forum, someone will revert you with codes.

You may also try recording macro.

Regards,

 

[Deepak]

Check this.


http://www.vbaexpress.com/kb/getarticle.php?kb_id=544

 

[manoj_th]

Check this.


http://www.vbaexpress.com/kb/getarticle.php?kb_id=544

Thanks