Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.csv Re-Format Question
Hello,
I copied from a source a spreadsheet that is apparently in .csv format. When I paste it into a regular Excel 2007 spreadsheet, everything is on one line; the columns don't seem to have any significance. How can I rfeformat this .csv such that all the columns (that are apparently there between the commas) are now placed in actual the Excel columns ? Thanks, Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
.csv Re-Format Question
If you Open the file (ctrl-o), then excel will use your windows list
separator/delimiter to parse your .csv file. If your windows delimiter is a semi-colon (common outside the USA), then you could see this problem. But if your windows settings match the data, ctrl-o should work ok. If you're just copy|pasting and it still goes into a single column (not a single row), then you can use Text to columns (on the Data tab of the Ribbon, _I think_) and follow the wizard to parse your data based on that comma delimiter. ===== And just a warning... If you do the copy|Paste a second time in the same session of excel, don't be surprised it excel remembers your choices. This can be a helpful feature (sometimes!). Bob wrote: Hello, I copied from a source a spreadsheet that is apparently in .csv format. When I paste it into a regular Excel 2007 spreadsheet, everything is on one line; the columns don't seem to have any significance. How can I rfeformat this .csv such that all the columns (that are apparently there between the commas) are now placed in actual the Excel columns ? Thanks, Bob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Question | Excel Discussion (Misc queries) | |||
format question | New Users to Excel | |||
Format Question | Excel Discussion (Misc queries) | |||
Format % Question | Excel Worksheet Functions | |||
Format Question | Excel Worksheet Functions |