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