Find and delete text from a cell with lots of text.
Hi there,
I'm pretty new to macros and I've been trying to do the following:
I have a sheet with codes, such as
abc-1
abc-12
bca-65
and so on...
And I need to lookup those codes in another sheet, where those codes are in cells, such as:
abc1-, abc-12, cba-45, aaa-1, mvn-98, etc etc.
Other cells have similar values as well, so I need a macro that finds those codes and remove them from the cells in the other sheet. I'm using Excel 2010.
Thanks in advance everyone.
Clarifying, the codes are lots in one cell.
So in cell a3, for instance, I have lots of codes separated by commas. The same in cell b3, c3, d3.
Help anyone?
Can you post an example workbook?
:-)
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
Re: Find and delete text from a cell with lots of text.
Hi Mike,
Thank you for your reply.
Attached is an example workbook.
I want to look and find the values from sheet "to be deleted" in the "base" sheet, and delete them if the exist in the "base" sheet.
The codes are inside cells, comma-separated.
Thank you very much.
Hi Give This A Try,
Post back any issues.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks