[aaac]

I want to split a column with employees names, some of the names are separated by "," and some are separated by " ". How can I take the first name if they are separated by " " and the last name if they are separated by "," ??

PLease help!

[Tango_and_Saucepans]

do u have the names in separate columns?

[aaac]

NO, they are in the same column. And I want to take one part or another(depends if they are separated by "," or by " ") and put it in a different column

[Tango_and_Saucepans]

oh you would be better to separate them out, is there alot to separate out? because otherwise it could be incredably tricky

[aaac]

that's what i need that formula for to separate this column and take only the values i need

[Ian]

Originally Posted by Tango_and_Saucepans

oh you would be better to separate them out, is there alot to separate out? because otherwise it could be incredably tricky

I think thats the problem Tango_and_Saucepans...

aaac - I'm not sure on an easy way to do this but you may be able to export the file as a txt/csv and then import it using a different ruleset to seperate them. Worth a try anyway

[Tango_and_Saucepans]

Right, ok sorry, just trying to help... i'm just going by what i learn at GCSE and in keyskills

[muckshifter]

Originally Posted by aaac

that's what i need that formula for to separate this column and take only the values i need

Here you go ...

http://www.ozgrid.com/Excel/TextFormulas.htm