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.

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

just use

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

--

HTH

Bob

just use

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

--

HTH

Bob

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

--

HTH

Bob

--

HTH

Bob

1. Finding last cell to contain same value as current cell?

2. Search/Filter to find values in another range based on two cell values

3. Split a cell containing two numerical values into two separate cells in VBA

4. Returning a value in one cell from values in two other cells

5. Select value on a cell by matching value of two cells

6. Find Cell with Value and get Value of Cell Below it

7. Finding last cell with a value and then adding to another

8. Sum Values after finding last cell

9. find first and last values in a row of cells

10. Finding the Value in a Last-Filled Column-Cell

11. Finding value in the last cell in column A

12. Find last cell with matching value

13. find the value of the last digit in a cell

14. FIND CELL VALUE THEN INCREASE THE VALUE OF THE ADJACENT CELL

5 post • Page:**1** of **1**