Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 02-26-2019, 08:57 AM
AlcatelUser AlcatelUser is offline Windows 10 Office 2016
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

Attached Images
File Type: png sample.png (107.7 KB, 7 views)
Reply With Quote
Old 02-26-2019, 09:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

Hi and welcome
please post a sample sheet (csv) so we can work on it
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Old 02-26-2019, 10:00 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 680
NoSparks will become famous soon enoughNoSparks will become famous soon enough

To create multi line text in a cell in Excel, you would use Alt+Enter to go to the next line which gives a chr(10) within the text
CRLF is chr(13) chr(10)
Have you tried removing the CR while in Notepad++ ?

I would have tried but your picture doesn't give anything like what you show when loaded into Notepad++
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from Excel into Word sb003848 Word 1 11-04-2014 06:30 PM
DAO for Excel 2010 import NobodysPerfect Word VBA 4 03-01-2014 02:12 AM
import labels from excel tactical Mail Merge 3 05-29-2012 04:03 PM
Import excel data in to SQL Server DavidBrown Excel 0 08-08-2011 04:49 AM
import tasks from excel with a macro o add-in milplus Project 1 03-02-2010 01:25 PM

All times are GMT -7. The time now is 06:04 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft