Newby search and replace

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Newby search and replace

Postby snapper1969 » Tue Feb 25, 2014 7:55 am

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

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

Re: Newby search and replace

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

Only with an Excel macro, not with TextPipe
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 4 guests