converting excel wortksheet to text

oercim

Guest

Posts: n/a

1st Dec 2006

Let there is such a data sheet:

column1 column2 column3
------------ ------------ ------------
john 32 london
jack 40 new york
then I want to convert this sheet in to text file like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad

« Row menu Insert control ID changes | Items in a discontiguous range »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting excel file to text	Jeff Granger	Microsoft Excel Discussion	6	2nd Jul 2007 10:48 PM
converting excel wortksheet to text	oercim	Microsoft Excel Programming	4	1st Dec 2006 11:12 AM
Converting text to excel	=?Utf-8?B?bWFkdWJvaXM5?=	Microsoft Excel Misc	3	26th May 2006 07:52 PM
Converting Excel to Text	Gomathi	Microsoft Dot NET Framework Forms	1	14th Oct 2005 05:33 PM
Converting excel to text file - Issue with wrapping text	giridar	Microsoft Excel Misc	7	27th Aug 2004 06:34 PM