| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to display text
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 | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
