Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2019, 08:57 AM
AlcatelUser AlcatelUser is offline CSV Import in Excel Windows 10 CSV Import in Excel Office 2016
Novice
CSV Import in Excel
 
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, 13 views)
Reply With Quote
  #2  
Old 02-26-2019, 09:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline CSV Import in Excel Windows 7 64bit CSV Import in Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
please post a sample sheet (csv) so we can work on it
Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-26-2019, 10:00 AM
NoSparks NoSparks is offline CSV Import in Excel Windows 7 64bit CSV Import in Excel Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV Import in Excel Import data from Excel into Word sb003848 Word 1 11-04-2014 06:30 PM
CSV Import in Excel DAO for Excel 2010 import NobodysPerfect Word VBA 4 03-01-2014 02:12 AM
CSV Import in Excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft