| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find last space
Can you let me have the function for finding the last space in a string?
At the same time, for future ref the #th space in a string please. My present problem is to separate the number at the end of a series of strings, typically: 0 - Council and Club Meetings 27 I need to find the last space in order to separate 0 - Council and Club Meetings and 27 into two cells using =LEFT() and =RIGHT() Francis Hookham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using FIND function to locate space between first and last name | Excel Worksheet Functions | |||
| How to find and replace blank space (x) in John Smithx in Excel? | Excel Discussion (Misc queries) | |||
| Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| Find last space from the right of text | Excel Discussion (Misc queries) | |||
Threaded Mode
