- Jun 2, 2011
- 6
- 0
- 0
Hey all, I've stumbled onto a problem and it's bothered me for days. Hoping for an Excel guru to offer some advice! I may not be looking at this in the most effective or efficient manner..
Problem
I'm exporting into Excel from a CMS and it is outputting a list of names all into one cell. I need the name in its own individual cells for each respective person. In the example below, there are three persons contained in one cell.
Example of a cell: Last, First,Last, First,Last, First
My Best Guess
It seems to be outputting the names into one cell, but there is a unique identifier between the names. The first name of the first person and the last name of the second person have a comma and no spaces between them. I've made this unique delimiter bold in the example above.
Is there a way I can use wildcards or something in Find and Replace to spot this? I've tried *,*, but the wildcards are recognizing spaces as well.
Why?
If I can find a way to use Find and Replace to spot this, I want to change the comma delimiter between persons to something more uncommon, to act as the delimiter in the Text to Columns feature so I can split each persons name into its own cell.
Problem
I'm exporting into Excel from a CMS and it is outputting a list of names all into one cell. I need the name in its own individual cells for each respective person. In the example below, there are three persons contained in one cell.
Example of a cell: Last, First,Last, First,Last, First
My Best Guess
It seems to be outputting the names into one cell, but there is a unique identifier between the names. The first name of the first person and the last name of the second person have a comma and no spaces between them. I've made this unique delimiter bold in the example above.
Is there a way I can use wildcards or something in Find and Replace to spot this? I've tried *,*, but the wildcards are recognizing spaces as well.
Why?
If I can find a way to use Find and Replace to spot this, I want to change the comma delimiter between persons to something more uncommon, to act as the delimiter in the Text to Columns feature so I can split each persons name into its own cell.
Last edited: