When I open CSV files in Excel 2010 I get entire rows in cells, not distributed according comma separation.
How to control this?
Microsoft Excel – How to Control CSV Import in Excel 2010
csvmicrosoft excelmicrosoft-excel-2010
Related Solutions
Go to the Data tab and select text to columns under data tools then select delimited and hit next. Then select comma as the delimiter and hit finish
The question seems to be "How do I copy only visible cells?"
The answer is:
- Select only the visible cells by first selecting the range then using GoTo (Alt+G), Special, Visible Cells only [This is the same as Sean Cheshire's answer of using Alt-; to select the visible cells only but it shows the path more explicitly].
- Ctrl+C (to copy)
- Go to a second sheet and paste them (Ctrl+V)
Best Answer
Open Excel and go to the
data tab - from text - select the file - import - delimited - next - comma - next - (settings) - finish.This will import your CSV file into Excel and will delimit it appropriately. Note if your CSV file uses something other than commas as separators, just choose that during the option selection phase.
Alternatively, if you've already opened it you can select the column and go to
data - text to columns - delimited - comma - finishand that will break up your column across the row(s).