Search for a character subsequent to its first appearance

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use "*xyz" in a formula 2
Character Search a cell 8
Need a Function 3
Extract one character 5
Find position of first non-matching character 18
How to perform Search and Replace on "Tilde", CHAR(126), ~ 2
Is it possible to search for the "?" character 3
VLOOKUP source values are a formula result. Getting #N/A 7

Top