JoanieBall
New member
- Joined
- Sep 9, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2019
Hi all-
I have a spreadsheet I'm working on where I pasted the values and it caused duplicate values to appear in the same cell. Here is an example below of what it looks like:
I want to remove the duplicate values within the cell so it just shows:
I've tried using the different VBA macro's around the internet but they don't seem to work for this issue. I can't use the Text to Columns either since that won't help in separating out the values.
Can you help me?
I have a spreadsheet I'm working on where I pasted the values and it caused duplicate values to appear in the same cell. Here is an example below of what it looks like:
John SmithJohn Smith | |
Amy SchulerAmy Schuler |
I want to remove the duplicate values within the cell so it just shows:
John Smith | |
Amy Schuler |
I've tried using the different VBA macro's around the internet but they don't seem to work for this issue. I can't use the Text to Columns either since that won't help in separating out the values.
Can you help me?