I have a simple spreadsheet for people to fill in for information like
supplier name, etc.
My problem is, everyone should be putting supplier name in the exact same
way - same spelling spacing, etc...but it's not happening. Is it possible to
set up a cell to only accept certain name?
For example:
correct spelling: ABC Inc.
incorrect: A.B.C Inc. , ABC Incorp, ABC Inc
There is just one ABC Inc. and I want to control and eliminate spelling
errors/variation.
is this possible to do in excel?? please help!
THANKS!