Can you not sort it back the way it was after you eliminate the rows with
text? Perhaps it would be easier if you could give an example of what the
real data is like?

"Luis" wrote:

Thank you Tim, that gave me a good idea, however I need to relate the data in
order, and sorting changes the order. If you have any other ideas, it would
be greatly appreciated.
Thank you
Luis

"Tim M" wrote:

You should be able to do a 'sort' of your data, it should sort the text in
one group and the numbers in another, then just delete the rows with numbers.
does that help?

"Luis" wrote:

Does anyone know how to select data from either odd or even rows and put in a
consecutive fashion. I have text in the odd rows and numbers in the even
ones. I want to get rid of the numbers and have only text, but it doesnt
happen. thank you for anyones help.