Thread: Extracting data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DestinySky DestinySky is offline
external usenet poster
 
Posts: 16
Default Extracting data

I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What
am I doing wrong??