Extract the last word from a text

jm -
jm - 20 Aug 2009 at 17:20

Hello,
I would like to extract the last word from a text. For example: "rue des plates pierres" I want to retrieve the word pierres

Configuration: Windows XP Firefox 3.0.13

Liens connexes:

2 réponses

Réponse 1 / 2

michel_m Posted messages 18903 Registration date Status Contributeur Last intervention 3 320

Try this custom function:

Function last_word(texto As Range) As String tablo = Split(texto) last_word = tablo(UBound(tablo)) End Function

--
Regards, Michel

Very well, thank you.

Réponse 2 / 2

michel_m Posted messages 18903 Registration date Status Contributeur Last intervention 3 320

And with which language and/or software+version?
--

I am using Excel 2003.