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

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?