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.