Posted to microsoft.public.excel.misc

cisem

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert column data to semicolon delimited text string	Richard RE	Excel Worksheet Functions	1	September 5th 06 03:03 PM
convert text to number for a range of data in a column	Tom	Excel Discussion (Misc queries)	9	October 31st 05 11:28 PM
Convert text to column	JN	Excel Worksheet Functions	4	April 14th 05 05:49 PM
How to convert columns of data to one column of text	devlkat	Excel Worksheet Functions	3	April 6th 05 04:08 PM
convert column data into text	Charlie	Excel Discussion (Misc queries)	1	January 30th 05 12:47 AM

All times are GMT +1. The time now is 07:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us