Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV File
Just downloaded my cell phone phonebook as a CSV file. What an ugly mess.
Each piece of data is separated by a ";". I would like to take each piece of data between the semi-colons and place it into its own cell. Please help with a macro or other advice. Thanks Phil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV File
All your data should be in one column... select that entire column and then
click on Data/Text To Columns on Excel's menu bar. When the dialog box comes up, select the Delimited option and click Next. Check the Semicolon box and uncheck any other boxes, then click Next. You can format any column on this dialog page (select the column, then select a format option for it). Click OK. Rick "2GWLAN" wrote in message ... Just downloaded my cell phone phonebook as a CSV file. What an ugly mess. Each piece of data is separated by a ";". I would like to take each piece of data between the semi-colons and place it into its own cell. Please help with a macro or other advice. Thanks Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |