Last word of a string without standard format

M

maryfung25

Please advise.

Eextract the last word "ccccc" from the "abc aaa bbbb ccccc"

No standard format, can be different size of each word, can have many spaces
within the strong.
 
N

Niek Otten

Hi Mary,

=RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

Replace "#" with another symbol if it can occur in your text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Please advise.
|
| Eextract the last word "ccccc" from the "abc aaa bbbb ccccc"
|
| No standard format, can be different size of each word, can have many spaces
| within the strong.
|
|
| --
| Many Thanks.
|
| Best regards,
| Mary
 
Top