+ Reply to Thread
Results 1 to 2 of 2

Remove new line characters in spreadsheet

  1. #1
    Registered User
    Join Date
    02-25-2020
    Location
    Seattle
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    9

    Remove new line characters in spreadsheet

    Hi,

    I have an excel sheet with data downloaded from a tool and there are columns that has free-form text in it. This free-form text contains line breaks, semi-colons, colons and comma - basically it can include anything.


    For my project, I have to uplaod a tab delimited form (.txt) file of this excel workbook to push the data to a DB and then eventually query the data. When I try to do this, the .txt file populates with new line characters just giving me errors when I uplaod to the system due to datatype mismatch.

    My question here is how do I remove new line characters formation in .txt file? I should possibly curate my excel sheet before saving it as .txt format. But unsure the best way to do it. Please also note that the data size is huge (nearly 20000 rows) - so looking for an easy less time consuming approach.

    I have attached a sample workbook for reference
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Remove new line characters in spreadsheet

    Perhaps something more like this?

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Remove slashes, insert X in front of first character and remove last to characters
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-29-2020, 03:31 AM
  2. [SOLVED] Remove characters from cells if the have non data and characters as per attached sheet
    By khanaran in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-17-2019, 02:35 PM
  3. How to Remove the existing new line characters in a excel cell?
    By HITLER in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2018, 08:19 AM
  4. Remove Text characters, leaving numerical characters
    By aschwalge in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-01-2016, 06:42 PM
  5. [SOLVED] VBA, remove all characters within a string, except numerical characters and full stops
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2015, 09:24 PM
  6. [SOLVED] MultiLine Textbox to auto remove blank line, count line, remove duplicate
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2015, 09:28 PM
  7. Remove all characters before space in line
    By gartie in forum Excel General
    Replies: 9
    Last Post: 08-29-2012, 05:52 PM

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