Thread: Extracting values need help ASAP!!! :o)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
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??

You are going to kick yourself<g....

=RIGHT(A1,4)

Rick

Reply With QuoteReply With Quote