I’ve got some data:

As you can see some cells have multiple names in them. I want one name per cell. Is there a function i can do to make happen?

Highlight required text.
Ctrl + X.
Ctrl + V.

😉

IAN an ITbod.

have you tried the text to columns option in the data menu?

as long as your names are separated (delimited) by the same character (comma or something) that should do it.

What acjim said.

Brilliant! I thought i’d have to write some convoluted code! Cheers.

text to cols will work if you’re doing this once and not trying to automate it. If you are, then you need something cleverer.

Hmmm, it’s deleting other text… i might have to do something with the destination.

You’ll need enough blank columns for the names to fill – so if you’ve got 10 names in one cell, you’ll need 9 blank columns before the next populated cell.

I copied and pasted it to Word, saved it as .txt file, opened that into an xml editor to strip the formatting, pasted back into word, saved as a .txt file, then changed the .txt to .csv and reopened in excel.

Problem solved.