title: Substring in Excel2010
body: <p>I'm working on an Excel file and I need to seperate a long string divided by "|" into different strings
  for example:
  "AB100|AB101|AB102|AB103"</p>
  
  <p>I need to seperate them into - AB100, AB101, AB102, AB103</p>
  
  <p>Thank you!</p>