Simple Find & Replace code required

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,635
Office Version
  1. 2007
Platform
  1. Windows
Evening,

For some reason a certain part number in my worksheet doesnt get entered correctly.

So can somebody wright me a simple code to find this number in a specific column & once found replace it with the correct number.

This is the infro that you will require to assist you.

Worksheet is called HONDA LIST

Will always be looking in column E

Part number to FIND is 08E56-CAT-888

Replace it with part number 08E56-CAT-888-02

Thanks
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,108,452
Messages
5,523,068
Members
409,496
Latest member
SWH

This Week's Hot Topics

Top