| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data=convert text to column
hello,
i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
Save your data first and use a copy of the file as follows......
Highlight the column A, the do Data TextToColumns and use the semicolon as the delimiter.... Vaya con Dios, Chuck, CABGx3 "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
Hi,
Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
I can do it like you say but i want it automatically . when i open the
document, it is automaticaly devided to columns. "Jean-Guy": Hi, Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
What you are wanting then, will require a Macro, not just a formula or
procedure. The macro would need somewhere to reside, so would have to be in a Master Workbook that you would open first, then retrieve the CSV file. If that is the sort of solution you are looking for, post back and someone will help. Vaya con Dios, Chuck, CABGx3 "cisem" wrote: I can do it like you say but i want it automatically . when i open the document, it is automaticaly devided to columns. "Jean-Guy": Hi, Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
In my office ,my friend opens excel like I write. he doesnt run a macro or anything. I suppose that it is a feature of excel. "CLR": What you are wanting then, will require a Macro, not just a formula or procedure. The macro would need somewhere to reside, so would have to be in a Master Workbook that you would open first, then retrieve the CSV file. If that is the sort of solution you are looking for, post back and someone will help. Vaya con Dios, Chuck, CABGx3 "cisem" wrote: I can do it like you say but i want it automatically . when i open the document, it is automaticaly devided to columns. "Jean-Guy": Hi, Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüştür) but I want it automatically |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
Check your Windows regional settings. If the list separator is set to
semi-colon, rather than comma, then it should open your CSV ([SC]SV?) file the way you want. -- David Biddulph "cisem" wrote in message ... In my office ,my friend opens excel like I write. he doesnt run a macro or anything. I suppose that it is a feature of excel. "CLR": What you are wanting then, will require a Macro, not just a formula or procedure. The macro would need somewhere to reside, so would have to be in a Master Workbook that you would open first, then retrieve the CSV file. If that is the sort of solution you are looking for, post back and someone will help. Vaya con Dios, Chuck, CABGx3 "cisem" wrote: I can do it like you say but i want it automatically . when i open the document, it is automaticaly devided to columns. "Jean-Guy": Hi, Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüstür) but I want it automatically |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data=convert text to column
It's ok now. thank you David.
"David Biddulph": Check your Windows regional settings. If the list separator is set to semi-colon, rather than comma, then it should open your CSV ([SC]SV?) file the way you want. -- David Biddulph "cisem" wrote in message ... In my office ,my friend opens excel like I write. he doesnt run a macro or anything. I suppose that it is a feature of excel. "CLR": What you are wanting then, will require a Macro, not just a formula or procedure. The macro would need somewhere to reside, so would have to be in a Master Workbook that you would open first, then retrieve the CSV file. If that is the sort of solution you are looking for, post back and someone will help. Vaya con Dios, Chuck, CABGx3 "cisem" wrote: I can do it like you say but i want it automatically . when i open the document, it is automaticaly devided to columns. "Jean-Guy": Hi, Have a look at Text to Columns under the DATA menu, if you have any problems post back! Regards! Jean-Guy "cisem" wrote: hello, i have problem about csv format. when i open the document it open like below 121;1454;6555;5423 but I want to devide the column to the columns (all data is devided to different column) like this=121|1454|6555|5423| I can do it manually by using (veri=metni sütunlara dönüstür) but I want it automatically |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert column data to semicolon delimited text string | Excel Worksheet Functions | |||
| convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
| Convert text to column | Excel Worksheet Functions | |||
| How to convert columns of data to one column of text | Excel Worksheet Functions | |||
| convert column data into text | Excel Discussion (Misc queries) | |||
Linear Mode
