Finding & Replacing a list of Data in Multiple Columns
 

I have a large amount of data that I have to replace in an excel spread
sheet. The columns look like:

Old
New
Column A Column B Column A
Column B
0012705 E200 3411 B0108 0012705
E200 3411 B0108
0012705 E200 3411 C0012 0012705
E200 3411 F1023
0012705 E200 3411 E3564 0012705
E200 3411 G8795

0012705 E200 3411 H5423

I either need to delete the information in Old Column A or B or replace Old
Column B with the new Column B.

Thanks

Finding & Replacing a list of Data in Multiple Columns
 

Where does the new Column B come from?

Pete

On May 5, 3:46*am, Me wrote:
I have a large amount of data that I have to replace in an excel spread
sheet. *The columns look like:

* * * * * * * * *Old * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * New
Column A * * * * * Column B * * * * * * * * * * * * * * * *Column A * * * * *
* *Column B
0012705 * * * * * * E200 3411 B0108 * * * * * * * * * *0012705 * * * * * *
E200 3411 B0108
0012705 * * * * * * E200 3411 C0012 * * * * * * * * * *0012705 * * * * * *
E200 3411 F1023
0012705 * * * * * * E200 3411 E3564 * * * * * * * * * *0012705 * * * * * *
E200 3411 G8795

0012705 * * * * * *E200 3411 H5423

I either need to delete the information in Old Column A or B or replace Old
Column B with the new Column B.

Thanks