+ Reply to Thread
Results 1 to 2 of 2

Help with "Insert a line break in a cell"

  1. #1
    Registered User
    Join Date
    02-05-2015
    Location
    Ohio
    MS-Off Ver
    Excel
    Posts
    38

    Question Help with "Insert a line break in a cell"

    Hi experts

    So I got the ALT+ENTER function to work perfectly (as found here https://support.office.com/en-us/art...7-9f5873fe21c7) but when I then copy & paste that cell outside of Excel it adds " " at the start and end of the pasted text.
    Can I get rid of the extra " " ?

    If it's any help, this is the formula before the ALT+ENTER has been added
    ="A "&D4&" review is being conducted on "&D2&" who has a final risk rating of "&D5&". "&K13&" "&E7&" "&E8&" "&D9&" "

    This is after the ALT+ENTER is used
    ="A "&D4&" periodic review is being conducted on "&D2&" who has a final risk rating of "&D5&". "&K13&"

    "&E7&"
    "&E8&"

    "&D9&""


    Thanks for any help.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Help with "Insert a line break in a cell"

    I'm afraid this is to do with the way other programs 'understand' Excel's line breaks and there isn't one easy solution to 'fix' it.

    You're not the first to be bothered by it - perhaps one of the solutions mentioned in one of these threads might help:
    https://www.excelforum.com/excel-gen...p-text-op.html
    https://www.excelforum.com/excel-gen...-suppress.html
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ 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. VBA to insert pictures to " insert comment " or "Text box" in cell E5 and E15
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 08:10 PM
  2. controlling the format of a "Line Break"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2013, 11:53 AM
  3. Macro to Insert Page Break Where "A" Column Changes Value
    By theoak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2013, 05:45 AM
  4. insert a line in excelsheet before a row where cell value in Column A is "XYZ11"
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2011, 04:16 AM
  5. Replies: 4
    Last Post: 12-29-2009, 08:11 PM
  6. How HardDisk neme "N" or "?" (as cell value) insert into macro formula?
    By frenic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2008, 08:40 AM
  7. Writing an "insert page break" macro
    By ellisande in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2007, 04:02 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