+ Reply to Thread
Results 1 to 2 of 2

.CSV, remove multiple lines in one cell

  1. #1
    Registered User
    Join Date
    11-28-2009
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    6

    .CSV, remove multiple lines in one cell

    Hello. I have a large .CSV file, which has some cells that has multiple lines in them. It is as if enter has been pushed and made them into tall cells. Can this be removed somehow?

    110016 15 15001 FORDELERLOKK 210B080432/ X035650/ 203A237174/ 203F177685/ 203R028782/ 209F000107/ 210B438527/ 210X065665/ 220A250448
    110016 15 15001 FORDELERLOKK 210B080432/ X035650/ 203A237174/ 203F177685/ 203R028782/ 209F000107/ 210B438527/ 210X065665/ 220A250448
    110016 15 15001 FORDELERLOKK 210B080432/ X035650/ 203A237174/ 203F177685/ 203R028782/ 209F000107/ 210B438527/ 210X065665/ 220A250448
    110002 15 15001 FORDELER 95410/ 50,20/ 60128440 95412/ 52,22/ 62075298 95510/ 50,20/ 60003550 95512/ 52,22/ 62000456
    110003 15 15001 FORDELER "95410/ 50,20/ 60128440
    95412/ 52,22/ 62075298
    95510/ 50,20/ 60003550
    95512/ 52,22/ 62000456"

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: .CSV, remove multiple lines in one cell

    Are you referring to this part?

    110003 15 15001 FORDELER "95410/ 50,20/ 60128440
    95412/ 52,22/ 62075298
    95510/ 50,20/ 60003550
    95512/ 52,22/ 62000456"

    There is a double quote after the word FORDELER, which forces everything up to the next double quote into a single cell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1