Google spreadsheet left formula with ellipsis

Question

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.

Answer 1

yes, use:

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

update:

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

Answer 2

I would only add the ellipsis when there are more than 600 characters

=IF(LEN(A1)>600;CONCATENATE(LEFT(A1;600);"...");A1)

This formula is from LibreOffice Calc