title: How to Extract Data in a string in Excel
body: <p>I have some data as aaa.4A.aa, 4A-AAA, AAA/4A, AA.a.4.A.AA in excel and I want to extract only 4A from all these strings in Excel.</p>
  
  <p>I have tried with substitute and replace with find functions.</p>
  
  <p>=IF(ISNUMBER(SEARCH("4a",A2)),"4A"</p>
  
  <p>I want 4A from all the above mentioned string in excel. Help me with the formula.</p>