Topics Map > Microsoft Office 2016 > Excel

Excel - Splitting Piped Delimited Columns

How to split pipe delimited excel files

Excel - Splitting Piped Delimited Columns

1)     Open the excel file you want to split.

2)     Highlight column A

3)     Click "Text to Columns" in the "Data Tools" group on the "Data" tab. This opens the "Convert Text to Columns Wizard" dialog box.

4)     Select the “Delimited” radio button

5)     Select "Other" and enter a "|" in the "Delimiters" section. Verify that the data looks corrects in the "Data Preview" section then click "Next."

6)      Click "Finish."

7)      This opens the “Microsoft Excel” dialog box, click “Ok”


  






Keywords:excel; delimited; pipe   Doc ID:69766
Owner:Nancy M.Group:University of Mississippi Medical Center
Created:2017-01-04 13:00 CSTUpdated:2017-06-07 11:57 CST
Sites:University of Mississippi Medical Center
Feedback:  0   0