if you have data in cell A1 then put in B1
=MID(A1,FIND("#",A1)+1,100)
Henk Wrote:
Ok
I have this
Check #275884
I need only 275884, how do I do so.
Thanks
Henk
"Pete_UK" wrote:
Perhaps if you could post a few examples of what you have, someone
might be able to suggest a way to split the numbers out.
Pete
Henk wrote:
How do I copy only the numbers from a cell with numbers and text
and symbols
to a new cell?
--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=570732