Find second to last value in cell
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.
|