Jul 14 2019 08:12 PM
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.
Jul 14 2019 08:24 PM - edited Jul 14 2019 09:01 PM
SolutionIf you have a column of cells to process, I suggest using the Data...Text to Columns menu item.
Jul 14 2019 08:32 PM
Jul 14 2019 08:24 PM - edited Jul 14 2019 09:01 PM
SolutionIf you have a column of cells to process, I suggest using the Data...Text to Columns menu item.