Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default converting excel wortksheet to text

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 like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 138
Default converting excel wortksheet to text

Just save your file as CSV file (That's comma delimited, so if you really
need semicolons you will have to search/replace them afterwards)

Joerg



"oercim" wrote in message
ups.com...
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 like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default converting excel wortksheet to text

thansk alot, it worked
Joerg wrote:
Just save your file as CSV file (That's comma delimited, so if you really
need semicolons you will have to search/replace them afterwards)

Joerg



"oercim" wrote in message
ups.com...
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 like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default converting excel wortksheet to text

If you don't want to have to save the entire file you can do this:
=A1&";"&B1&";"&C1
throw a space inside the quotes as well if you need spacing. This assumes
column 1,2,3 are A,B,C Formula in D just copy and paste.
-John

"oercim" wrote:

thansk alot, it worked
Joerg wrote:
Just save your file as CSV file (That's comma delimited, so if you really
need semicolons you will have to search/replace them afterwards)

Joerg



"oercim" wrote in message
ups.com...
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 like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad



  #5   Report Post  
Posted to microsoft.public.excel.programming
bz bz is offline
external usenet poster
 
Posts: 16
Default converting excel wortksheet to text

"oercim" wrote in news:1164960827.378202.289120@
79g2000cws.googlegroups.com:

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 like,
john;32;london
jack;40;new york
I have thousands of such data. If u help me , I will be very glad


something like

Worksheets("outsheet").Cells(row_out, column_out).Value = _
Worksheets("insheet").Cells(row_in, 1).Value & ";" & _
Worksheets("insheet").Cells(row_in, 2).Value & ";" & _
Worksheets("insheet").Cells(row_in, 3).Value






--
bz

please pardon my infinite ignorance, the set-of-things-I-do-not-know is an
infinite set.

remove ch100-5 to avoid spam trap


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
converting text from word to excel. darkfeld Excel Discussion (Misc queries) 5 October 20th 08 04:14 PM
Converting a date to a text field w/o converting it to a julian da LynnMinn Excel Worksheet Functions 2 March 6th 08 03:43 PM
Converting text to excel madubois9 Excel Discussion (Misc queries) 3 May 26th 06 07:52 PM
Converting a Text file to Excel ExcelUser[_2_] Excel Programming 2 January 14th 04 03:42 PM
macro for converting text file to excel Tom Ogilvy Excel Programming 0 September 5th 03 12:49 PM


All times are GMT +1. The time now is 10:53 PM.

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

About Us

"It's about Microsoft Excel"