+ 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
    Office 365
    Posts
    831

    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 2007,2010,365
    Posts
    44,093

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

    Use CHAR(13)
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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
    Office 365
    Posts
    831

    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 2007,2010,365
    Posts
    44,093

    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)

Similar Threads

  1. Google Sheets - line up orders by turnover or quantity
    By Ymmies in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 01-18-2019, 08:28 AM
  2. Replies: 4
    Last Post: 01-11-2019, 06:38 AM
  3. Google sheets: Return certain text with exclusion
    By rayted in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-02-2018, 08:04 AM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. [SOLVED] Text and transpose function (google sheets)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 08-18-2018, 09:03 AM
  6. google sheets copy and repeat line
    By Ditch1983 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-10-2017, 04:33 AM
  7. combining sheets (code works from ron debruin but need 1 line modification)
    By Piyush in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2005, 12:38 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