View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Quick/Easy Question?

Using Excel 2003...

I have a worksheet with three columns.
-In the first column I have data containg a name and position #. For
example, Joey Doe 01199.
-In the second column I would like to extra only the numerical values. How
can I do this? For the example above I would like to extract 01199.