Find from a1 Replace then paste in to call b1

pranav - Sep 28, 2009 at 03:05 AM
 Blocked Profile - Sep 28, 2009 at 09:46 AM
i am searching a formula.
to find a word from Column A1
& replce with my own word and paste in to B1 in excel
how it is possible


1 reply

Blocked Profile
Sep 28, 2009 at 09:46 AM
Advanced Find & Replace is an add-on for Microsoft Excel, it will help you in facilitating you first task and try looking in the following post for your second task:

It talks about creating a macro in order to facilitate your task of copying and pasting.

Hope this helps you.

Thank you.