Excel Help

Trigger · 12 Jun 2007 at 18:53

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:

Code:

     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:

Code:

   A       B
Bloggs    Joe

Thanks for any advice

Ben

MarcLister · 12 Jun 2007 at 19:25

I think I've worked it out for ya. I can email you an Excel spreadsheet with some formulae that as far as I can tell do what you want. Or I can add you on MSN?

Trigger · 12 Jun 2007 at 19:30

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 :cool:

Ben

MarcLister · 12 Jun 2007 at 19:31

Grr! Well we both learned something then. I don't have that feature in Office 2000.

whitecrook · 23 Jun 2007 at 23:39

out of date now probably but just import as text and choose comma as the delimiter, then save back to csv?

TheKnat · 24 Jun 2007 at 10:25

whitecrook said:
out of date now probably but just import as text and choose comma as the delimiter, then save back to csv?

I normally do this as well but that link looks interesting.