Help needed: Removing rows if it doesnt start with number

How about:

Please Login or Register  to view this content.

Try it with the modified line.

Please Login or Register  to view this content.

The help here is something incredible. So i got now 3 vba files. They work when i use them in one by one. I would like to combine them in one if its possible (I can pay 5$ with paypal for the first working answer)

First one removes all alphabetics exept 0 to 9 and - (I need this because i got some info from data scraping in these rows that starts like asd 1234567-4, that i need in my school project)
Second one removes empty rows that i got from data scraping.
Third one removes all the rows that wont start with numbers, like - and asd.

Here is example of my rows in excel..
A1 TEXT That i dont want to remove
A2 1234567-1
A3 asd 1234567-2
A4
A5 -
A6 1234567-3
A7 1234567-4
A8 asd 1234567-5
A9 asd asd asd
A10 1234567-6
A11
A12
A13 -


The result that im looking for is like
A2 1234567-1
A3 1234567-2
A4 1234567-3
A5 1234567-4
A6 1234567-5
A7 1234567-6

So no numbers lost, only alphabetics and empty rows ( and rows with only -)

BR
Aletzi

I forgot a parenthesis

Please Login or Register  to view this content.

Sorry, I misread the OP, You want to keep numbers and deleted letters. Try this one.

Please Login or Register  to view this content.

BTW, no charge if it works. Not allowed on this site.

@ JLGWhiz,

This will cost you $1000.00

The OP wants the Code to Run from Row two. You don't have to specify lower case "a-z", and you may include other special characters like /, \, |, *,~,-.

So your Code will look like this:

Please Login or Register  to view this content.

Now please pay up or else.

Regards.

@Winon - Never could get the hang of the regex without using the handbook.

Wat kyk jy bakerman2?

Hi there Buddy.

Nice to see you so active!

Regards.

Beware Tjaart, Big Brother is always watching you my man.

Hello aletzi1,

Welcome to this Forum.

Do you want the results to be as shown below, and will it apply to Column A only?

A2 1234567-18asdasd = 123456718
A3 1234567-2 = 12345672

Regards.

Originally Posted by Winon

Hello aletzi1,

Welcome to this Forum.

Do you want the results to be as shown below, and will it apply to Column A only?

A2 1234567-18asdasd = 123456718
A3 1234567-2 = 12345672

Regards.

Hi and thanks for replying. Column A only. I would like to result shown as

A2 1234567-1asdasd =1234567-1
A3 ASD1234567-2 =1234567-2
A4 - = Delete row, because no numbers
A5 "Empty row" = Delete this row
A6 LETTERS ONLY = Delete this row

So no letters, no spaces, no empty rows. I only need that - to be in the rows that has number on it, like seen on A2 and A3. So rows with - only, no need and can be deleted.

I think this vba should first delete alphabetics, after that rows with only - and after this rows that are empty / has only spacebar on it i really dont have skills to do this by myself, this forum has helped me so much already. 😎

Hope this clear out what i mean

Thank you for the clarification, aletzi1.

Actually, your requirement has changed twice from the original Post, but here we go.

Please Login or Register  to view this content.

Please try the attachment, and enjoy.

Regards.

Hi and thanks for huge help on my project. This is not still what i am looking for

original.PNG
This is what its looking original. I got about 70000 rows of this kind of information.

inneed.PNG
And this is how i need it to look.
I can do this with 2 vba files that i already have, but i need to combine them into one working vba and i really got no skill. 5$ is still in the game

I don't get it - your original code with the fix as in Post #10 seems to work just fine

Originally Posted by xladept

I don't get it - your original code with the fix as in Post #10 seems to work just fine

Sorry, it does not work way it should.
original.PNG

After i run that code from post #10
after.PNG

It is missing 1656611-2, there is asd letters in 1656611-4 and its missing also 1656611-5.

Hi aletzi1,

Please try the revised attachment.

Regards.

I'll give it one more shot.

Please Login or Register  to view this content.

Try this on your mock up sheet.

A little different than original:

Please Login or Register  to view this content.

Originally Posted by JLGWhiz

I'll give it one more shot.

Please Login or Register  to view this content.

Try this on your mock up sheet.

This removes asd 1656611-2, 1656611-5 and leaves text: 1656611-4asd

Hi aletzi1,

You are welcome, glad we could help. Just email me a Copy of $1000.00 note(bill).

Thank for the Rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

Hello Hi aletzi1,

I first wanted to get your approval on the basic approach on my latest sample Workbook, without error trapping. If you Click on the 'Click' Button after your Data has been cleaned you will receive an error message.

To take care of that, please replace the Code in the sample Workbook with the Code below, as a "Fix".

Please Login or Register  to view this content.

Regards.

Thanks for the rep!

@ xladept,

You stingy low whatever. I can't even compare you to a cockroach

You are obliged to give me at least 75% of the Rep+, you have received.

Thanks for your valuable contribution in this Thread, buddy.

Kind regards.

@ Winon - Yeah, a cockroach can hold it's breath under water for an half-hour!

@ xladept,

You are forcing me to set your hair on fire, so that you could slap yourself dead.

@ Fluff13,

And what are you looking at?

@ Winon - Oh! No! You're too scary - I'm going to hide now