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