I have a 244 names and when I have people type the names I get 4 or 5 variations to the name when collecting data. Is there a way that I can have the person start typing the name and have the correct spelling appear after 3 or 4 letters are typed? If this works I believe I can correct problems with multiple name variations.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Fill Name
- Thread starter DarrenF
- Start date
In my data I get "John Smith","Jon Smith", "John Smit". I would like to have the person just type something like "Joh", then it would show "John Smith" you hit enter then it puts the correct spelling in the cell. Like if I duplicate a name that is in the next cell down, I can get it to pop up with the correct spelling. Does that make sense?
Upvote
0
Amanda Wilso
Board Regular
- Joined
- Dec 18, 2016
- Messages
- 132
If auto fill does not work then follow the steps
1.Click on FILE
2. GOT TO "ADVANCED"
3. UNDER EDITING OPTIONS "CHECK" Enable fill handle and cell drag-and-drop
4.Click OK
1.Click on FILE
2. GOT TO "ADVANCED"
3. UNDER EDITING OPTIONS "CHECK" Enable fill handle and cell drag-and-drop
4.Click OK
Upvote
0
I would go into Excel Options, under Proofing, AutoCorrect Options
then in the box that says Replace: I would write in Jon and in the box for With: I would write in John. I would do this for all variations of the names. Then I would repeat the same for all of the last name variations.
Just know that if you use this or any method you will probably end up with errors on names because you may have typed Jon but meant Jones. You could also put in the Replace Joh or Jon and John Smith into the With but if you have more than one John you will end up with a whole bunch of John Smiths when you may have wanted John Doe.
<tbody>
</tbody>
then in the box that says Replace: I would write in Jon and in the box for With: I would write in John. I would do this for all variations of the names. Then I would repeat the same for all of the last name variations.
Just know that if you use this or any method you will probably end up with errors on names because you may have typed Jon but meant Jones. You could also put in the Replace Joh or Jon and John Smith into the With but if you have more than one John you will end up with a whole bunch of John Smiths when you may have wanted John Doe.
| Replace: | With: |
| jon | John |
| joh | John |
| smit | Smith |
| stephen | Steven |
| stev | Steve |
| jone | Jones |
<tbody>
</tbody>
Last edited:
Upvote
0
