Search code examples
if-statementgoogle-sheetsconcatenationgoogle-sheets-formulatextjoin

Google spreadsheet left formula with ellipsis

I'm using importxml to import some data from an other website. This results in some cells to show long text. I'm using =LEFT formula to limit the number of characters in a cell but words stop very abruptly and i was wondering if i can add ellipsis ... (three dots which mean "text continues") to my formula. Something like =LEFT(B25;600) ... which should result in "word word w..." Is this possible?

I tried adding three dots in next cell but they show even when text is not shortened so it does not make sense.

Solution

  • yes, use:

    =LEFT(B25; 600)&"..."

    update:

    =IF(LEN(B25)>600; LEFT(B25; 600)&"..."; B25)