Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can you tell me how to find the position number of the third space in a
string of varying length and text. e.g., 123 456 789 111 222 need to find position number of space between 789 and 111 or in: abcd efghi jklmnopqr stuvxy need position number of space between "r" and 's'. I am familiar with =find(" ",a1) to find a space but need help with logic for third or second space. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you find the position of the first value (< 0) in a list | Excel Discussion (Misc queries) | |||
How do i get the last position of a char (space) in a string? | Excel Worksheet Functions | |||
find number position in excel text cell | Excel Discussion (Misc queries) | |||
find position of a number in a string | Excel Worksheet Functions | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) |