Names

**mowerracer74** · 02-18-2012, 02:14 PM

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

**gjlindn** · 02-18-2012, 03:36 PM

Hi there...are you saying they'll be typing in their full name again or will they be typing first names into one column and last name into another column? Thanks!

**mowerracer74** · 02-18-2012, 04:13 PM

Yes their full name. Mmmm say for example when you are entering list of names in a column:-

Jason Smith
Jason Brown
Jason White
Jason Green

If you typed the next name, Jason W, excel would assume it was going to be Jason White. This is what i want, but the list of names is actually referenced from the other cells so it wont work for me!

I think that is as clear as Mud!!! lol!

**gjlindn** · 02-18-2012, 04:32 PM

See the attachment and tell me if something like that would accomplish what you're looking for. Thanks!

**mowerracer74** · 02-18-2012, 05:34 PM

Yeh, Almost. One thing i noticed, i am trying to do this on my Company PC and it has Excel 2002 on it, not 2010, does this matter??

**mowerracer74** · 02-18-2012, 05:41 PM

Signed in on my company PC now, that works, BUT, i want to do it the other way. So i have two columns with the split names and then they will be typing there whole name in the cell with their full name.

I will have a look in help to see how your function works?!?

**protonLeah** · 02-18-2012, 05:49 PM

Please amend your title per:
1. Use concise, accurate thread titles.
*Your post title should describe your problem, not your anticipated solution.
*Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

**mowerracer74** · 02-18-2012, 06:05 PM

Originally Posted by protonLeah

Please amend your title per:
1. Use concise, accurate thread titles.
*Your post title should describe your problem, not your anticipated solution.
*Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

If i could work out how to edit my post title i would! Although, i do not know what i would call it, otherwise i would know how to do it? I am new to this forum and to excel, so i apoligise if i have done anything wrong.

**mowerracer74** · 02-18-2012, 06:10 PM

I have attached a file, If a user types thier name in cell B,626 i would like it to try and match it to one of the names above, so that they user does not have to type their whole name. Any ideas?