| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Search for a character subsequent to its first appearance
Hi,
The worksheet function SEARCH finds the first appearance of a character or text string within another text string (or array of text strings). Does anyone know a way to 'tweak' SEARCH to look for the Xth appearance of a character. For instance, in "Brian M. Johnson", I would like to search for the second "space" and have my fuction return 9. Your help is much appreciated. |
|
#2
|
|||
|
|||
|
Search for a character subsequent to its first appearance
=SEARCH("#",SUBSTITUTE(A2," ","#",2))
Henrik wrote: Hi, The worksheet function SEARCH finds the first appearance of a character or text string within another text string (or array of text strings). Does anyone know a way to 'tweak' SEARCH to look for the Xth appearance of a character. For instance, in "Brian M. Johnson", I would like to search for the second "space" and have my fuction return 9. Your help is much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Character Search. | Excel Worksheet Functions | |||
| search more than one character | Excel Worksheet Functions | |||
| How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
| Is it possible to search for the "?" character | Excel Worksheet Functions | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Linear Mode
