Not quite the same, but maybe you could apply Data|Filter|autofilter to column
A.

Then you could use the dropdown to do a custom filter:
begins with
ends with
contains
to find all the matching entries.

Confused at Work wrote:

I have a customer list in column 1 from a4 to a500. I want to be able to in
a1 type some letters and the customer corresponding to the letters i am
typing in comes up. Exactly like a search engine for excel. Any help on
this?

--

Dave Peterson