converting excel wortksheet to text

[oercim]

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

 

[Joerg]

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]

thansk alot, it worked

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

 

[Guest]

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

 

[bz]

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.

(e-mail address removed) remove ch100-5 to avoid spam trap