hey, i want to load my users in with a vbs script into active directory from a text file. I only got one problem the text layout is different, i mean: How it works

John, Bond, Strangepasword, test
James, Bond, Strangepasword, test

But my text file is set up like
John
Bond
Strangepasword
test

James
Bond
Strangepasword
test

How to fix this, i know my vbs script seperates cells by ",". Should i change it in vbsscript yes? how? should i change the text file with another program to match the layout, like excell. if so how do i do this?

Thx

I don't know vbs script however you CAN do this in Excel if necessary because Excel allows for string "arithmetic".

Say you had the follow in cells C3-C6 in an Excel spreadsheet:
John
Bond
Strangepasword
test

In another cell you can put the following formula in:
=C3&", "&C4&", "&C5&", "&C6

Which would result in:
John, Bond, Strangepasword, test

Notice the formula uses & rather than + to "add" strings. Also notice you have to include literal strings within double quotes. Finally notice that you have to include the space after the comma in your literal string to insure you have the space in the result.