Macro Loop with What If function

Hi Guys

I have a problem for my Master thesis. I have been downloading tweets for the past 3 month and now im trying to get them into order.
the columns are in the following order:
1) ID = A
2) Username = B
3) Date = C
4) Time = D
5) Status = E

As i imported the tweets into Excel the Status got messed up when somebody hit Enter in his/her tweet. Then the part after the Enter-sign got inserted into the next row in column A (ID)

I therefore created a Macro that joined the Status with the next rows column A. See here:

Please Login or Register  to view this content.

Also if somebody hit Enter twice a blank row occurs in between the actual tweets. I also created a Macro for that:

Please Login or Register  to view this content.

This all works out fine if i do it manually. HOWEVER, there are almost 100.000 tweets and if i go through all of them it will take me days.
I want to create a loop that starts in column A and goes through. Everytime there is no number in a cell it should check whether the cell is empty and use the second macro or whether it has some other things in it (mostly text) and use the first macro.

I dont have any idea how to do this. can somebody help? I 'd appreciate it a lot!!

Please Login or Register  to view this content.

That works for your sample.

Edit: actually it will get stuck eventually. put "End of tweets" in the last row and then use this instead:

Please Login or Register  to view this content.