Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel as Text (Tab delmited) | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) |