exporting excel to text with : delmited
 

i need to export list of users from ADUC to a group. I
have the list with excel spreadsheet and i need to export
it to text format with semicolon at end of each entry.
what is the best way to do this?

exporting excel to text with : delmited
 

In any version of excel, you could use a macro to write out the date using a
specified separator. Chip Pearson has code:

http://www.cpearson.com/excel/imptext.htm import/export text files

You can also save as CSV from the file = SaveAS menu and it should use the
list separator in your regional settings in Windows.

--
Regards,
Tom Ogilvy



"aj" wrote in message
...
i need to export list of users from ADUC to a group. I
have the list with excel spreadsheet and i need to export
it to text format with semicolon at end of each entry.
what is the best way to do this?