![]() Not sure if this is a difference between Windows and Mac, but once I made the change, I was able to get it done. ![]() Use Text to Columns (Data tab, Data Tools group) However, it should be CHAR(13) not CHAR(10), that's where I had trouble. Microsoft Excel can help turn this confused jumble into neat rows and columns. The screenshot below shows a jumble of comma separated values in a Notepad file. Let’s take a sample CSV file and walk through the steps to convert delimited text files to spreadsheets. To make the data formatting consistent in a column To reverse the concatenate function OR to separate the combined values in a cell. There are two purposes to use Text to Columns feature in Excel. In Pop up sceen 2/3 I can't insert the vertical > 'dash', as I could wiht my windows-PC (Keyboard Alt GR '1'). HTH|:>) Bob Jones Office:Mac On 4/23/10 4:11 PM, in article wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel > Hello, > When I want to import data in excel from another file, I have to use the > function text to columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |