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 int...
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
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!
