| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim "\" Value
absolutely.
-- Regards, Tom Ogilvy "Steve Garman" wrote in message ... Dave Peterson wrote: The code samples that used Split (or VBA.Split) will work for xl2k or higher. The other code is should work in all versions. (I didn't test, though.) Split was added in xl2k. And I think the same restriction applies to the InStrRev sample |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =TRIM(LEFT(B47,FIND(" ",B47)-1)) | Excel Discussion (Misc queries) | |||
| =TRIM(LEFT(B50,FIND(" ",B50)-1)) | Excel Discussion (Misc queries) | |||
| =SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
