Last word of a string without standard format

[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.

 

[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