Page 1 of 1

Newby search and replace

Posted: Tue Feb 25, 2014 7:55 am
by snapper1969
Hi,

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

Thanks,

John

Re: Newby search and replace

Posted: Tue Mar 04, 2014 9:27 am
by DataMystic Support
Only with an Excel macro, not with TextPipe