Thread: Extracting values need help ASAP!!! :o)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DestinySky DestinySky is offline
external usenet poster
  
Posts: 16
Default Extracting values need help ASAP!!! :o)
ok I have 000000VC3236 in a cell. How can I extract only the last 4 numbers,
3236?? I have tried =SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong??
Reply With QuoteReply With Quote