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