Extract the last word from a cell in Excel

preview_player
Показать описание
The video offers a short tutorial on how to extract the last word from a cell in Excel.
Рекомендации по теме
Комментарии
Автор

U should have pasted the formula in the title box

markjoseph
Автор

Formula:

=MID(F2, 1+FIND("~", SUBSTITUTE(F2, " ", "~", LEN(F2)-LEN(SUBSTITUTE(F2, " ", "")))), 255)

The squiggly approx sign is ALT + 126

breannagarcia
visit shbcf.ru