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

--

HTH

Bob

"Roger Govier" wrote in message
...
Very nice solution, Teethless Mama!
--
Regards
Roger Govier

Teethless mama wrote:
=TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198),99))


"Eric_G" wrote:

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.