View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
starguy starguy is offline
external usenet poster
 
Posts: 1
Default copy numbers from numbers+text cell


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