| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting text from word to excel. | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting text to excel | Excel Discussion (Misc queries) | |||
| Converting a Text file to Excel | Excel Programming | |||
| macro for converting text file to excel | Excel Programming | |||
Hybrid Mode
