use edit find replace
find item# with a trailing space if there is one in your cells
replace with leave this blank


--
Greetings from New Zealand

wrote in message
...
I have numerous cells that have the following listed in them ... Item#
0012631004
How do I pull only the number out of this cell?