Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement for alpha numeric combo AND numeric only | Excel Discussion (Misc queries) | |||
Alphanumeric Sorting - numeric alpha numeric | Excel Worksheet Functions | |||
only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
Split the numbers in a alpha numeric case | Excel Discussion (Misc queries) | |||
Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions |