Extract only text and numbers from a range that includes 0's and ""

**emricki** · 10-26-2011, 02:25 PM

Any ideas, using only Excel functions, on how to extract only nonblank text and nonzero numerical values from a column of data into a different column?

**tlafferty** · 10-26-2011, 02:30 PM

Assuming test values start in A1, put this formula in the first cell to which you want to "extract" values:

Please Login or Register  to view this content.

. After filling the formula down, copy and paste values in that column to convert to values.

**emricki** · 10-26-2011, 03:50 PM

I apologize for not being specific. The result I'm looking for is an array that contains only nonblank and nonzero values with no blank or 0 values inbetween the selected values; e.g., if the text range covers 100 cells say, and 25 noncontiguous cells have something other than a blank or zero, how can I extract a 25-cell array containing those values?

Thanx!