| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help with spaces in functions (Biff)
The formula you gave me =substitute(mid(f1,find("~",substitute(f1,"
","~",len(f1)-len(substitute(f1," ",""))))+1,255),right(f1,1),"")*1 works partley,it will only give me the first 3 rows with a result and the other 297 rows have a #value! result could you please help me I have tried to change parts of the formula but no luck thank you -- bill gras |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
Threaded Mode
