Extracting multiple entries in a cell into their component pieces
Each cell in column A contains multiple entries separated by a comma and a
space (e.g., P7899, P7899.7, P9250, P9261). Ideally, I would like to use a
built-in function (versus a custom function if possible) that extracts the
contents of each cell in column A and puts the component pieces into separate
cells in column B. Using the previous example, one cell in column A would
become four cells in column B.
Thanks for the help.
Bob
|