Hello,
I have cells that contain text strings within (every cell has a different character count of text in them). The one consistent among all of them is there is a "--" between the text in the cells.
I'm trying to find a way to remove the text characters and have them placed in their own string. I have an image shown below to help.
Is there a way to have each player name moved to it's own cell without using text to columns or VBA?
I have cells that contain text strings within (every cell has a different character count of text in them). The one consistent among all of them is there is a "--" between the text in the cells.
I'm trying to find a way to remove the text characters and have them placed in their own string. I have an image shown below to help.
Is there a way to have each player name moved to it's own cell without using text to columns or VBA?