Alpha with numeric and numeric only numbers in a column
On Fri, 18 Sep 2009 12:16:05 -0700, rciolkosz
wrote:
It returned above. It appears it only did every other line.
Mike's formula assumed your first entry as in A1. If you copied it, but did
not change the cell references appropriately, you might have see strange
results. Although I don't understand the "every other line" issue, nor the
fact, from what you show above, that you did not extract the entire number.
Please copy/paste the formula that you are using; and copy/paste the results.
Also, there may be something about the cell formatting that is throwing things
off.
--ron
|