Get the word before the last one

[leandrociscar]

Hello everybody,
i have this code that i get the last word of a cell, i wish i could get the word before the last one...but i'm having problems to get it...could anyone help please?

Please Login or Register  to view this content.

[Special-K]

This works

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ", REPT(" ",100)),200),100))

Source: http://www.mrexcel.com/forum/excel-q...rd-string.html

[leandrociscar]

Thank you so much man, you helped me a lot (=
this is solved.

[leandrociscar]

Thank you so much man, you helped me a lot (=
this is solved.