Thread: Extracting numbers from alphanumeric strings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Poonam Poonam is offline
external usenet poster
  
Posts: 3
Default Extracting numbers from alphanumeric strings
SSHRC856-2004-0033 Bielawski
SSHRC858-20-0027Nadasdi
SSHRC858-04-0001Daveluy
SSHRC856-04-010 Blair,H
SSHRC421-2005-03 Haggerty
SSHRC861-2005-025 Garvin

For e.g from above information is in Cell A, I want to have only no. like
from ISt 856-2004-0033, Could it possible by signle line formula.

Thanks in advance

Poonam
Reply With QuoteReply With Quote