Forum Discussion
Solved
Parsing 2 or 3 strings of text from a cell that are separated by "|"
Example 1:
XXXXX | XXXXX
Example 2:
XXXXX | XXXXX | XXXXX
Where XXXXX is a varied string of text separated by the "|" symbol
I need to be able to parse out each string of text into sequential cells in a row. Currently trying to use MID, LEFT, RIGHT, LEN, and IF in order to get around errors that would occur when a cell has 2 strings of text instead of 3.
If you have a column of cells to process, I suggest using the Data...Text to Columns menu item.
- Select the cells to be parsed. They must be in a column, unfortunately.
- Open the Data...Text to Columns menu item, and choose Delimited in the first step of the wizard. Click Next.
- In the second step of the wizard, choose the pipe | symbol as the delimiter in the field next to "Other". Click Next.
- In the third step of the wizard, you may specify where you want the results. It defaults to write over the original column.
- Click Finish
2 Replies
If you have a column of cells to process, I suggest using the Data...Text to Columns menu item.
- Select the cells to be parsed. They must be in a column, unfortunately.
- Open the Data...Text to Columns menu item, and choose Delimited in the first step of the wizard. Click Next.
- In the second step of the wizard, choose the pipe | symbol as the delimiter in the field next to "Other". Click Next.
- In the third step of the wizard, you may specify where you want the results. It defaults to write over the original column.
- Click Finish
- Thank you so very much! It worked like a charm!
