title: How to extract data from a concatenated string in excel macro
body: <p>Am new to this - trying to pull out a name and date from a concatenated text string - each line has a name with the month - all different and the month must be changed for each search.<br>
  [Attached is screenshot of my results using MID that extracts date][1]</p>
  
  <p>I have attempted MID and RIGHT using first uppercase to the left of the comma but have had no luck.
  Any help would be appreciated.</p>
  
  <p>I do have a script that process the data - the following is the VBA code for pulling name and date:
  Name 
      ActiveCell.Formula = "=IFERROR(MID(C3,1,FIND(""January"",C3,1)-1),IFERROR(MID(C3,1,FIND(""February"",C3,1)-1),IFERROR(MID(C3,1,FIND(""March"",C3,1)-1),IFERROR(MID(C3,1,FIND(""April"",C3,1)-1),IFERROR(MID(C3,1,FIND(""May"",C3,1)-1),IFERROR(MID(C3,1,FIND(""June"",C3,1)-1),IFERROR(MID(C3,1,FIND(""July"",C3,1)-1),IFERROR(MID(C3,1,FIND(""August"",C3,1)-1),IFERROR(MID(C3,1,FIND(""September"",C3,1)-1),IFERROR(MID(C3,1,FIND(""October"",C3,1)-1),IFERROR(MID(C3,1,FIND(""November"",C3,1)-1),IFERROR(MID(C3,1,FIND(""December"",C3,1)-1),""No matches""))))))))))))"</p>
  
  <p>Date
      ActiveCell.Formula = "=IFERROR(MID(C3,FIND(""January"",C3)*1,20),IFERROR(MID(C3,FIND(""February"",C3)*1,20),IFERROR(MID(C3,FIND(""March"",C3)*1,20),IFERROR(MID(C3,FIND(""April"",C3)*1,20),IFERROR(MID(C3,FIND(""May"",C3)*1,20),IFERROR(MID(C3,FIND(""June"",C3)*1,20),IFERROR(MID(C3,FIND(""July"",C3)*1,20),IFERROR(MID(C3,FIND(""August"",C3)*1,20),IFERROR(MID(C3,FIND(""September"",C3)*1,20),IFERROR(MID(C3,FIND(""October"",C3)*1,20),IFERROR(MID(C3,FIND(""November"",C3)*1,20),IFERROR(MID(C3,FIND(""December"",C3)*1,20),""nope""))))))))))))"</p>
  
  <p>I'm sure there is an easier way - I just haven't figured it out and I'm being pressured to get this data out - </p>
  
  <p>![1]: <a href="https://i.stack.imgur.com/dT92Q.jpg" rel="nofollow noreferrer">https://i.stack.imgur.com/dT92Q.jpg</a></p>