Newby search and replace

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Mon Feb 24, 2014 11:22 pm

Newby search and replace

Post by snapper1969 » Tue Feb 25, 2014 7:55 am


Totally new to this and hoping for a reply.

I have 2 excel sheets

sheet1 has a column of reference numbers like t12345
sheet2 has a column of reference numbers like df3srt12345hgfd4

is there anyway to find what cells in sheet2 contains within the reference number in sheet1 and replace it or create a new column beside it with the sheet1 reference.

Hope I have explained properly



User avatar
DataMystic Support
Site Admin
Posts: 2199
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: Newby search and replace

Post by DataMystic Support » Tue Mar 04, 2014 9:27 am

Only with an Excel macro, not with TextPipe

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Post Reply