Hi guys

I am a fairly basic user of excel and i am looking for some help.

I have a list of names approx 450. They are in the format : Surname, Christian in one cell.

I have managed to break them up and put them in a cell each and then place them back in a cell in the correct order and minus the comma by delimiting them and using the concatenate command or ="cell"&"cell" command.

My question is this, i know want to a user to type there name in a cell underneath the new list but as they are typing i want suggestions to appear as it would if the names had just been typed in? (does this make sense?)

Can anyone help me??

cheers

Jason