View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Walter H Walter H is offline
external usenet poster
 
Posts: 7
Default Extracting from a cell

I need help with a problem of taking info that I place in a cell and
extracting only a portion of it to another cell.

Example: In A1 I want to take the last 6 digits from an entry that is in
D1. the entry in D1 is a combination of alpha and numeric digits and is 17
digits long.

Any ideas?

Thank you.