View Single Post
 
Old 02-26-2019, 08:57 AM
AlcatelUser AlcatelUser is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 1
AlcatelUser is on a distinguished road
Default CSV Import in Excel

Dear community,

following problem:

I have an csv file which is an exported file with network inventory.

If I open this csv file in Excel it is not correctly formated.
Some information which belongs to the description should be in one cell.
But Excel makes a couple of lines out of it.

I am using the feature Data -> text to columns


If I open the same file in open Office or Libre office it is correctly formated.
The whole text which belongs to description is in one cell.

I attached a picture which should make it more clearly what I mean.

Is that a formating issue in Excel?

Best regards

DANIEL
Attached Images
File Type: png sample.png (107.7 KB, 15 views)
Reply With Quote