Thread: Extraction
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martina Martina is offline
external usenet poster
 
Posts: 25
Default Extraction

Dear Experts,
I have one cell which contains the following string of characters exactly in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina