Macro to combine cells in a row to 1 cell while skipping blank cells

Hey ajryan88

Thanks again for your awesome excel macro. It works perfectly. However, in addition to what the macro already does, it is possible to add another work sheet in the same work book that outputs the values in separate cells? It also has to output the data in order: for example, in the first work sheet the data is inputted at random and has spaces but the macro will have to remove all the blank cells and output them in order based on the first value in the test string, 1, 2, 3, 4, and then 5;


input:

blank 3-x Blank 1-y blank 2-z 1-k

output:

1-k 1-x 2-z 3-y

Please let me know if you can make this happen and what i can do in exchange for your help.

Thanks

-Yong

Let me know if this works for you?

Thanks again for your awesome macro and the speedy reply. It works just the way i wanted. I owe you one.

No problems

You can say thanks by clicking on the * next to my post

Do you mean the "Add Reputation" icon? when i click on it it says i have spread some reputation around before i can give it. What does that mean?