+ Reply to Thread
Results 1 to 2 of 2

How to Remove the existing new line characters in a excel cell?

  1. #1
    Registered User
    Join Date
    10-24-2018
    Location
    chennai
    MS-Off Ver
    ms 2016
    Posts
    1

    How to Remove the existing new line characters in a excel cell?

    Excel has totally 2500 rows.In this excel description column have some new line characters.

    We are trying to load (From Excel to Table) description column having more number of new line characters (Around 50 lines) in a cell and it got failed with error string contains untranslatable character.

    We have to set a character limit and remove characters over that limit in excel cell and load the data to table.

    Note: To install kutools need admin permission.so its not possible.

    Please let me know any other option is available to remove new line characters other than kutools.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: How to Remove the existing new line characters in a excel cell?

    Pls try this out:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Check here for more options : https://www.extendoffice.com/documen...ne-breaks.html
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

+ 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. Deleting characters or working in a line within an existing text file on the HDD
    By Grug.Crood in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2018, 11:44 AM
  2. Replies: 6
    Last Post: 03-03-2016, 10:02 PM
  3. [SOLVED] Formula to Add Additional Characters to an existing cell
    By Tamarissa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2015, 07:00 PM
  4. [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
  5. [SOLVED] Remove certain characters from a cell
    By M8R-l3mfmi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-03-2013, 05:15 PM
  6. Remove all characters before space in line
    By gartie in forum Excel General
    Replies: 9
    Last Post: 08-29-2012, 05:52 PM
  7. remove everything but the last three characters at the end of the cell?
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-21-2012, 09:24 AM

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