+ Reply to Thread
Results 1 to 2 of 2

line break

  1. #1
    Registered User
    Join Date
    08-04-2022
    Location
    panama
    MS-Off Ver
    windows10
    Posts
    1

    Lightbulb line break

    what symbol is this and how can I remove this line break, please

    simbolo excel.PNG

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: line break

    have you tried the clean function? Say it is in cell A1, then in another empty cell put =CLEAN(A1)
    The other thing is that if you can see them, you can try to copy them (as you've highlighted them in yellow) then open find and replace, find what >> paste the symbol there, then replace with >> leave empty, hit replace all and see if that cleans them up.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Removing multiple line breaks into single line break
    By anonymous321 in forum Excel General
    Replies: 7
    Last Post: 12-02-2020, 08:22 PM
  2. Replies: 4
    Last Post: 10-21-2020, 11:42 PM
  3. Replies: 4
    Last Post: 05-30-2018, 01:03 PM
  4. Copy pasting from Excel issue - NEW LINE/LINE BREAK
    By denneboom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2012, 10:18 AM
  5. Copy pasting from Excel issue - NEW LINE/LINE BREAK
    By denneboom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 06:40 AM
  6. [SOLVED] Break cell into multiple lines by line break
    By Chia in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 01:40 AM
  7. [SOLVED] line break in a cell-Is there a way to get the line break instead of a symbol?
    By luvgreen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2005, 02:05 PM

Tags for this Thread

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