Need Help with excel

[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]

Re

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]

re

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

 

[Ian]

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]

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