Is there a way in Excel to search (CTRL+F) for a word ending with a
certain letter, say 'e'. The words are typically not followed by a
blank space or a period.

So I was wondering if there is an advanced search that would find a
word beginning with, or ending with a certain letter.

Thanks in advance,
Patrice

---

Request for Question Clarification by pafalafa-ga on 28 Apr 2005 06:39 PDT

I believe a search on [*e ] -- with a space after the 'e' -- will find
all words ending with the letter e (provided they do, in fact, have a
space after them).

Try it, and let me know if it works out.

pafalafa-ga

---

Request for Question Clarification by pafalafa-ga on 28 Apr 2005 06:40 PDT

Ooops, sorry....just now noticed your caveat about "no spaces".  Ah well!

---

Request for Question Clarification by pafalafa-ga on 04 May 2005 13:06 PDT

patrice29-ga,

andykaiser-ga seems to have come up with a workable solution for you,
which is posted in the Comments section, below.

I just wanted to make sure you were aware of this...I tested it, and
it seems to work, as long as there is only one word per cell (if more
than one, it will only find the LAST word in the cell that ends with
"e").

Let us know if that works out.

pafalafa-ga

I don't think there is, but you can do this with conditional formatting. 
select cell A1
format... conditional formatting
set condition 1 to 
'Formula is' '=Right(A1)="e"'
then choose some conspicuous format option like bright yellow cell shading.
copy cell A1 then select the entire sheet, paste special... formats.
then every cell ending with letter e should get highlighted bright
yellow or whatever your chosen format was.

Hopefully somebody has a better solution.
Good luck

You can use custom filter. 
On the dropdown box there is an entry there (Custom..) 
Then on the Custom auto filter dialog choose equal 
then to select all words having e.g "hello" including "hello world" of "hi hello" 
enter "*hello*" as criteria. 

in your case you could try searching for "*e *" don't know if this
will work but perhaps through several iterations and creative searches
you may be able to filter the list.

You can use a wildcard or the character '*'.
for example if you want to search for a word that begins with the
letter 'a' and ends with the letter 'c', you just have to search for
'a*c'.
that will return every word of three or more characters that begins
with a and ends with c.
You can use more than one wildcard on a search.

Unfortunately, searching for *e will find every occurence of the
letter e, not just the ones that end a word. Likewise a* finds every
occurence of the letter a, not just at the begining of a word.

You don't need conditional formatting or anything too complicated.
Here's how to do it in Excel 2003:

1) Open the Find dialog box.
2) In the "Find What" box, type *e
3) Below that box, check the box that says "Match Entire Cell Contents"
4) Click "Find All" or "Find Next", and this will find all cells that
contain text ending with the letter "e".

For similar questions and tech info, see the "Mini-Bits" section at my
website: http://www.andybrain.com

andykaiser-ga you are right, this works!  You DA MAN!!!

well If you wish to search for a word ending with 'e' try this. in
search box use '*e' as search string and check 'Match entire cell
contents'. You can do other searches in this fashion.

I think it is the right answer. Just try this out.

Boonlia P K