# Search for word in cell

#### seacrest

##### Active Member
I want to find and certain word in a certain cell.This word will most likely be in a sentence.Can this be done without using vba

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
On 2002-10-05 04:30, seacrest wrote:
I want to find and certain word in a certain cell.This word will most likely be in a sentence.Can this be done without using vba

Have you looked @ Find or Search

Thanks Ivan but i need this to be built into my spreadsheet can you return a word from a sentence on a given cell.?With or without vba

On 2002-10-05 04:51, seacrest wrote:
Thanks Ivan but i need this to be built into my spreadsheet can you return a word from a sentence on a given cell.?With or without vba

Care to give some examples of sentences and the words that must be returned?

The cow jumped over the moon (Need to return cow)

Hi seacrest.

In cell B1 give cow. In C1 give formula =LEN(B1).

In A2 Your sentence: 'The cow jumped over the moon .

In B2 formula:

There is sure more simple answers, but this is mine.

Regards Sir Vili.

It works great thanks again

On 2002-10-05 05:36, seacrest wrote:
The cow jumped over the moon (Need to return cow)

Let A2 house the sentence and D2 the word "cow".

In B2 enter:

 A B 1 Site-Id(SH.Name2) 2 IN03XC115 Here's where I need my formula to search for A2 in the next tab called 'Sprint MMBS Inbox' 3 NY33HO062 4 NY33HO062 5 NY33HO062

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

Can you gentlemen help me, too?

Replies
1
Views
274
Replies
5
Views
269
Replies
7
Views
263
Replies
14
Views
442
Replies
2
Views
2K

1,196,308
Messages
6,014,580
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back