Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
aj aj is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Excel as Text (Tab delmited) tcmh Excel Discussion (Misc queries) 1 May 1st 09 08:41 PM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 29th 05 05:26 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 11:26 PM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 05:33 AM


All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"