Copy the formula I gave you into a text editor like notepad, do editreplace
and replace A1 with the cell reference where your data starts, so assume the
data starts in D4 replace A1 with D4, now copy the formula from notepad to
the formula bar in excel (or doubleclick a cell and paste it there), then
finish with ctrl + shift & enter and if done correctly you should get the
formula enclosed in curly brackets (so called array formula) like {formula}
Once done drag the formula cells fill handle to copy it to cover all the
cells necessary, hight light all cells you created qand copy them, do
editpaste special as values in place. Now you can replace the original data
with the extracted numbers


regards,

Peo Sjoblom

"jeremy via OfficeKB.com" wrote:

PEO

I'm new to excel--shift control enter ??

I severalspread sheets with a list of numbers

4000
4909AD
NHG
MJH0044
6787
"7878

I'm hoping to paste them into a column and then eliminate the letters and
puctuation, so that I have a range of numbers 0 to 9999. The text entries
can be zero....

Thanks

--
Message posted via http://www.officekb.com