sample.xlsx
I have uploaded a sample of data i need to sort out. In this, the string &&parent=xyz&& is common in every line of every cell. I need to identify this string and copy the line of the cell to another cell. there are 3 kinds of xyz so end result should be 3 columns with each cell containing the same &&parent=xyz&& string (i.e. same xyz).
Hello,
While I understand your need, it will easy to get the results if you upload the sample sheet "with your desired results" for few lines.
here is my desired result for row 1.
Try the attached
looks to be working fine, thanks. how do i apply it to a different worksheet?
Replace Sheets.Add with something like Sheets("Sheet2") if needed.
Please Login or Register to view this content.
Welcome to the Forum, askhari:
Your duplicate posts did not comply with Rule 5 of our forum rules. These threads have been merged.
When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them.
Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks