Excel 2007 : finding and returning the numeric cells in a column

hi,

i have an excel sheet with multiple rows of entries in column A. some cells are text, some are numbers, some are na(), etc. is there a function to extract only the numeric cells and output them to, say, column B? along the same line, can i also extract just the text, or the na(), etc?

i know i can use the data filter, and then do a copy-paste, but this gets very tedious if i have many such columns to work on.

thanks for your quick reply there. is there a way to extract as well as collate them into chunks of continuous cells, for easier further processing?

hi Marcol, pls see attached excel to understand what i am referring to.

what i have done was to basically extend from what you have shown earlier, by manual copy/paste-link of the filled cells. i want to remove the empty cells between the extracted numbers/text, as well as retain their original location, in case the original data has to be changed. is there a more automatic way to carry out this series of actions?

sorry, here is the excel file.

Where is your attachment?

[EDIT]

That was bad timing, I see it now!!

thanks. those functions look really complicated...will have to take some time to digest them