Help with textfunction

[silentwolf]

HI guys,

I am struggling to get the function to work to find me the position of the 4th last space within a string from the right.

String is like.. "Firstname Secondname Surname Myhome 23 8545 Westfield"
but it also could be like "Firstname Surname Myhome 5 4524 Testinghof"

Now I like to get rid of the adresses within the string..

So basically the result need to be like: "Firstname Secondname Surname"
or " Firstname Surname"

I was thinking of finding the 4th last space within the string. Tried with Find and substitute but as the name or better the empty spaces can vary I was out of luck getting it to work.

Could someone give me a hand with this please?

many thanks

Albert

 

[mikerickson]

Another option would be to change this line from post #2

Ary = Split(Cl & "    ", " ") ' append four spaces

 

[silentwolf]

Thanks again guys!!

I will try it!

Cheers much appreciated!