2.116 FAQ-1050 Does Origin have a tool like MS Excel's Text to Columns Wizard?

Last Update: 3/16/2020

Like MS Excel, Origin has a tool for splitting cell text into multiple cells (columns). The text should be Comma, Semicolon, Pipe or White Space delimited.

  1. Open the Script Window (Window: Script Window), type the following and press ENTER.
  2. text2cols -d
  3. In the Text to Columns dialog box, select the Text Column and Delimiter. If you would like to copy additional columns over to your output, check the Include Other Column(s) box and specify Other Column(s).
  4. Specify location for Output and click OK.
FAQ1050 text2cols 1.png

Keywords:string, parse, delimited, delimiter, split