• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find and replace

I

IKHAN

Member
Hi,

Looking for a macro to find and replace in specific sheet (Data) and in specific column (A) for mutilple entries and replace in excel 2010. have around 1000 entries and list grows every month.

Help will be really appreciated...

example :

Find :John Doe replace: John chang
Find :karla jin replace: karla clay
Find :ling peng replace: john peng
 
Without a sample file You would wait!
How do You think to control
which (find) text would replace 'correct text'?

And...
Why do You want to continue do FIND/REPLACE list monthly?
Would it be better to get those 'FIND' written correct way?
 
You must log in or register to reply here.
Back
Top