| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to display text
You're Welcome!
"Elton Law" wrote: Hi Teethless Mama, That was my mistake. Yours works. The rest works as well. I have tested. Thanks all of you. "Rick Rothstein" wrote: Off the top of my head... Second from last ================================ =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"\"&TRIM(RIGH T(SUBSTITUTE(A1,"\",REPT(" ",99)),99)),""),"\",REPT(" ",99)),99))&"\"&TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT( " ",99)),99)) Last ================================ =TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99)) Check back into this thread from time-to-time as I'm sure someone will post a much shorter formula than my "second from the last" one... the formula for the "last" should pretty much be the tightest one you will find. -- Rick (MVP - Excel) "Elton Law" wrote in message ... Dear Expert, I have a cell containing text as follows: R:\Team A \Client Vals\Equity Derivatives\Daily\Valuations Temp\Fixings.xls How can I display the text from second last of \ or last of the \ please ? In this case, for second last of \ should be Valuations Temp\Fixings.xls In this case, for last of \ should be Fixings.xls Thanks in advance, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display percentage with 0 decimal point by Text function? | Excel Discussion (Misc queries) | |||
| When I wrap text, excel hides the text display | Excel Discussion (Misc queries) | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| Function to display day in text format | Excel Worksheet Functions | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
Threaded Mode
