Autocomplete only works if the entire string matches from the beginning to the point where you are
typing. If the ending is the same (the @etc part), you could use a column of formulas to add that
part to the beginning part of the address:
With
firstname.lastname
in cell A2, the formula
=A2 & "@etc"
will return
firstname.lastname@etc
And then copy that formula down to match your list.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
