primeira palavra - =SE.ERRO(ESQUERDA(E2;LOCALIZAR(" ";E2)-1);E2)
última palavra - =EXT.TEXTO(E2; PROCURAR("[^ ]*$"; E2;1); NÚM.CARACT(E2) - PROCURAR("[ ][^ ]*$"; E2; 1))
Nota: é necessário ativar as expressões regulares em Ferramentas->Opções->Libreoffice Calc->Calcular
sudo apt install ttf-mscorefonts-installer
mkdir ~/.fonts
wget -qO- http://plasmasturm.org/code/vistafonts-installer/vistafonts-installer | bash
I just would like to summarize suggestions from comments here.
When an auto-completion suggestion is shown inside a cell (after a character is typed, suggested text is selected):
Ctrl + Tab cycles through all auto-completion values for the cell, on every key press, selected suggested text is replaced with the next suggestion
Alt + Down shows a pop-up select box under the cell with all auto-completion suggestions sorted alphabetically