Hello I'm looking for an easy way how to delete all cells in a single column if those cells start with ***.
The problem is that I can't just delete all rows with ***Record3 and ***Record5, because there are important data in other columns. So Record4 and Record6 must be moved one row up.
Thank you for any help.
Example:
Column A:
Record1
Record2
***Record3
Record4
***Record5
Record6
Output should be:
Column A:
Record1
Record2
Record4
Record6
Hiii please let me know length of all records to be delete is = 10 and others = 7???
Last edited by mangesh.mehendale; 09-28-2015 at 12:29 AM.
Don`t care, take care...
Regards,
Mangesh
Hello mangesh
Record1 ... Record6 is just an example. "LEN" can be anywhere between 4 and 250.
Okay and there is "***" (asterisk marks) or these are characters like (ABC or 123)
Is this how you wanted?
Please Login or Register to view this content.
Hi bonpara,
Try this (just initially on a copy of your data as the results cannot be undone if they're not as expected):
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
If you don`t want VBA Go with following steps
Step 1: Press Ctrl+H
Step 2: find- ~***(here * is treated as text) if these are asterisk marks of ABC* or 123* (here * represents series of character)..
Step 3: press find ALL(below all result will be visible press Ctrl+A to select all found results
Step 4: Press Ctrl + "-" and select Shift cells up and OK
Hello Jindon.
Thank you for your code. The problem with this code is that it will delete entire rows, so I would lose data in other columns. So I need to clear cells with a data starting with *** (three asterisks) and move data in column "A" up.
OK then this should doOriginally Posted by bonpara
Please Login or Register to view this content.
Hello Robert,
Thank you very much for your code. As I mentioned earlier, the problem is that It will delete entire rows so I would lose data in a same row but in other columns.What I need is to clear cells with the asterisks at the beginning and then MOVE rest of the data up, so it won't delete entire row.
But thank you anyway for trying.
Bonpara
This is It. It works perfet. Thank you Jindon, you really helped me a lot.
Thank you very much.
OK then this should do
Please Login or Register to view this content.
You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks