Find second to last value in cell

[Eric_G]

Unless most "right" or "left" functions in which one is looking to select the
"LAST" or the "FIRST" value within a string of characters within a call, I
wish to select the "SECOND TO LAST" value within a string of characters
within a call. IN other words, assume the string of characters of a cell
ends with "Fname Lname". I wish to select "Fname" from the character string
and place it in another column. Any ideas? Much appreciated.

 

[Teethless mama]

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198),99))

 

[Roger Govier]

Very nice solution, Teethless Mama!

 

[Bob Phillips]

Looks like overkill to me, the RIGHT seems superfluous as it seems fine to
just use

=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

 

[Bob Phillips]

Oops, my mistake, I missed the OPs request for Second to last