View original (French)

Extract the last word from a text

jm -  
 jm -
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

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor 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
    7
    1. jm
       
      Very well, thank you.
      1
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    And with which language and/or software+version?
    --
    1
    1. jm
       
      I am using Excel 2003.
      1