Prev: How do I change the pge size to A4 in excel 2003
Next: Group or ungroup in a shared excel workbook
From: ks1 on 25 May 2010 06:04
excel has to search for a paticular letter in a row and print the preeciding
word in the next cell
From: Per Jessen on 25 May 2010 06:17
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" <ks1(a)discussions.microsoft.com> skrev i meddelelsen
news:62BC47D5-A3F8-4880-B406-35923D9B4520(a)microsoft.com...
> excel has to search for a paticular letter in a row and print the
> preeciding
> word in the next cell

From: Steve Dunn on 25 May 2010 06:44
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" <ks1(a)discussions.microsoft.com> wrote in message
news:62BC47D5-A3F8-4880-B406-35923D9B4520(a)microsoft.com...
> excel has to search for a paticular letter in a row and print the
> preeciding
> word in the next cell

From: Steve Dunn on 25 May 2010 06:50
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" <stunn(a)sky.com> wrote in message
news:DE5C6706-E5C4-4820-8059-E0401C47AA95(a)microsoft.com...
> 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" <ks1(a)discussions.microsoft.com> wrote in message
> news:62BC47D5-A3F8-4880-B406-35923D9B4520(a)microsoft.com...
>> excel has to search for a paticular letter in a row and print the
>> preeciding
>> word in the next cell
>

From: Jacob Skaria on 25 May 2010 07:06
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
 | 
Pages: 1
Prev: How do I change the pge size to A4 in excel 2003
Next: Group or ungroup in a shared excel workbook