| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find nth position of word
I have this list of strings: A1:A4
I like apples apples are green would you like some apples the apples are on the table I'd like to know for each cell in which nth position is apple. And I'm happy to define "word" as something between two spaces. Which formula in B1 could give me the answer for A1? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the position of a date | Excel Discussion (Misc queries) | |||
| How do you find the position of the first value (< 0) in a list | Excel Discussion (Misc queries) | |||
| lock position of Word object in protected excel spreadsheet | Excel Worksheet Functions | |||
| lock position of Word object in protected excel spreadsheet | Excel Discussion (Misc queries) | |||
| Return an Alpha based on number position in a word | Excel Worksheet Functions | |||
Threaded Mode
