| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return a text that is before "/"
Dear All,
I have tried MID, FIND, LEFT function but to no avail as the length of a string can vary: 97/2008 98/2008 99/2008 108/2008 109/2008 495/2008 496/2008 CORRECTION 3/2008 498/2008 What I need to achieve is to have a function that will return everything before "/" and without any "space" at the end: e.g. it will return 498 only without emtpy space (something like TRIM). Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can lookup return cell reference istead of "text" for sumif? | Excel Worksheet Functions | |||
| IF cells(row,column) contain "this word" ??? Then return text | New Users to Excel | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
![Piotr (Peter)[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
