Search for a particular letter in the sentence and print

excel has to search for a paticular letter in a row and print the preeciding
word in the next cell

Hi

This formla search for '!' and return whatever is found after the '!' sign.

=IF(FIND("!",A1),MID(A1,FIND("!",A1)+1,99),"")

Hopes this helps
....
Per

"ks1" skrev i meddelelsen
...
excel has to search for a paticular letter in a row and print the
preeciding
word in the next cell

Hi, I'm a little confused, do you have a row of cells with content such as:

A1:
testing x this y formula z

B1:
this p is q the r next s cell t along u

C1:
and a another b example c for d luck


and wish to search A1:C1, returning, for example, "the" when your criteria
letter is "r"?

If not, perhaps you could clarify your requirements a little further.

Steve D.


"ks1" wrote in message
...
excel has to search for a paticular letter in a row and print the
preeciding
word in the next cell

Or, is it more like one cell containing a sentence.

A1:
perhaps this is could work

and you wish to return, for example, "is" when your criteria letter is "u"?

This could become very messy. If, for instance, your criteria letter
appeared twice in the sentence (not unheard of grin) what would you want
your result to be?



"Steve Dunn" wrote in message
news
Hi, I'm a little confused, do you have a row of cells with content such
as:

A1:
testing x this y formula z

B1:
this p is q the r next s cell t along u

C1:
and a another b example c for d luck


and wish to search A1:C1, returning, for example, "the" when your criteria
letter is "r"?

If not, perhaps you could clarify your requirements a little further.

Steve D.


"ks1" wrote in message
...
excel has to search for a paticular letter in a row and print the
preeciding
word in the next cell

Try the below....which search for an exclamation in row1 range(A1:Z1) and
returns the cell value of the next cell...

=INDEX(A1:Z1,SUMPRODUCT((ISNUMBER(SEARCH("!",A1:Z1 ))*
COLUMN(A1:Z1)))+1)

--
Jacob (MVP - Excel)


"ks1" wrote:

excel has to search for a paticular letter in a row and print the preeciding
word in the next cell