Need to find the word in Sheet 2 ,A Column and Replace With # Before the word and after the word
EG-Tyne and Wear will replace like first data shown here
A19 Film & Video Mulgrave Ter N/A N/A Gateshead #Tyne and Wear# NE8 1PQ North East Office & Administration 2-5 - Film Studios & Production Services 9
A19 Fleet Driver Development The Lodge Sandy Lane N/A Billingham Cleveland TS22 5NA North East Head Office 1 3-9 Driving Schools
A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed
A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed
A19 Pools & Spas 9 Lister Road N/A North West Industrial Estate Peterlee County Durham SR8 2RB North East Head Office 2-5 LT 3 Hot Tubs Spas And Whirlpools 5
A19 Pools & Spas 2 South Side Retail Pk Portrack Lane N/A Stockton-on-Tees Cleveland TS18 2TA North East Office & Administration 6-10 LT 3 Swimming Pool Contractors, Repairers & Service
A19 Smart Car 2 Hardwick Court N/A Blackhall Colliery Hartlepool Cleveland TS27 4FB North East Workshop & Repair Centres 2-5 LT 3 Car Valet Services 5
A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6
A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6
A19 Film & Video Mulgrave Ter N/A N/A Gateshead #Tyne and Wear# NE8 1PQ North East Office & Administration 2-5 - Film Studios & Production Services 9
A19 Fleet Driver Development The Lodge Sandy Lane N/A Billingham Cleveland TS22 5NA North East Head Office 1 3-9 Driving Schools
A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed
A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed
A19 Pools & Spas 9 Lister Road N/A North West Industrial Estate Peterlee County Durham SR8 2RB North East Head Office 2-5 LT 3 Hot Tubs Spas And Whirlpools 5
A19 Pools & Spas 2 South Side Retail Pk Portrack Lane N/A Stockton-on-Tees Cleveland TS18 2TA North East Office & Administration 6-10 LT 3 Swimming Pool Contractors, Repairers & Service
A19 Smart Car 2 Hardwick Court N/A Blackhall Colliery Hartlepool Cleveland TS27 4FB North East Workshop & Repair Centres 2-5 LT 3 Car Valet Services 5
A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6
A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
