+ Reply to Thread
Results 1 to 4 of 4

Insert new line (within formula which is combining text) - GOOGLE SHEETS

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    276

    Insert new line (within formula which is combining text) - GOOGLE SHEETS

    Hi guys

    Using google sheets.

    Here is my formula which I am using to combine text. can anyone help me so that i can insert text onto a new line (in the cell)

    ="You got 20 points a total of " & C11 & " times" & ", your breakdown is as follows:" & " League: " & C14 & " correct scores" & " Cup: " & C15 & " correct scores"

    (I want 'league:' and 'cup:') to be on two new lines, within the same cell

    Please can anyone advise?

    Grateful.!

    R.
    Thanks,

    R.



  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,051

    Re: Insert new line (within formula which is combining text) - GOOGLE SHEETS

    Use CHAR(13)
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    276

    Re: Insert new line (within formula which is combining text) - GOOGLE SHEETS

    thank you Trevor!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,051

    Re: Insert new line (within formula which is combining text) - GOOGLE SHEETS

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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