View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cisem cisem is offline
external usenet poster
 
Posts: 4
Default 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