I can't see where Excel is not correct. It just waits with its suggestion
until there is no ambiguity left. If the only text in your column starting
with letter B is 'Blaa', then Excel offers 'Blaa' after entering just a B.
If you have another entry in your list such as 'Blaa foo', Excel waits until
you have entered 'Blaa ' (with a trailing space) to offer 'Blaa foo'.
Makes sense to me. The space has no effect the other data in the column...at
least in Excel2003.

Joerg

"Jason" wrote in message
...
Help states: "completes text entries that you start to type in a column of
data ? if the first few letters that you type match an existing entry in
that
column."

But, if I have a single space between entries in the column, excel
"forgets"
all of the data in the column and doesn't offer any suggetions. Is there
any
way to correct this?