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

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

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

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

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