Excel Help

[Trigger]

Hi,

I need to create a CSV file to bulk import about a hundred or so users into AD. I have been given an excel worksheet with the names in this format in one column:

     A
Bloggs, Joe

I need to separate the first name and surname to form the username (Via the concatenate function) Basically, I would like to know if there is any excel function (Or work around methods if there aren't any) to separate the names at the comma or space and put them into two separate columns like so:

   A       B
Bloggs    Joe

Thanks for any advice

Ben

 

[Trigger]

Think I've sorted it now. Had a look on Microsoft's website (Which I should have done first ) and found this: Link which seems to do exactly what I want Thanks for looking for me though- much appreciated

Ben