bulk find replace.

**tobiahjadam** · 11-12-2009, 08:51 PM

Hello,

I have a list of 30k rows containing text strings.
I also have a list of 600 key words.
Each of the 30k rows only has 1 of the key words
I want to automate the process of searching the 30k rows for the key words and replacing the string with the key word it contained.

From what I can figure the solution to this is an excel Macro.

Can anyone help?

Thank you in advance.

**Leith Ross** · 11-12-2009, 11:36 PM

Hello tobiahjadam,

Welcome to the Forum!

This macro may need some changes. It was written using the following assumptions: The keywords are on a separate sheet and in a single column, and the rows being searched are on a separate sheet in a single column.

If your data is not arranged this way then you need to show me how it is arranged. I can then change the macro to work with the data.

Here is the macro code. Data for both sheets starts in cell "A1".

Please Login or Register  to view this content.

**tobiahjadam** · 11-13-2009, 12:12 AM

Hello Leith,

Thank you very much for getting back to me as quickly as you have.

I am very new to macros.

Could you help me understand what the code means?

A1 referrers to the first word entry in the two lists right?
Sheet one contains the list of key words or the list of text strings?

Also how do I implementing this code?

Again, thank you for any help you have time to provide.

**Leith Ross** · 11-13-2009, 02:18 AM

Hello tobiahjadam,

If you can post a sample workbook or the complete workbook, I can add the macro in for you. It will also give me a chance to run the macro on the actual data and make any needed adjustments.