LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default cell parameters?

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL & Like Parameters George Applegate[_2_] Excel Discussion (Misc queries) 2 November 2nd 07 06:11 PM
populating a cell with parameters Shannon Bisram New Users to Excel 4 October 8th 06 08:00 PM
Getpivotdata - able to reference to another cell all parameters but not the datafield Roger The Rabbit Excel Discussion (Misc queries) 6 September 3rd 06 03:10 PM
Too few parameters lou sanderson Excel Discussion (Misc queries) 1 January 13th 06 06:35 PM
too few parameters lou sanderson Excel Discussion (Misc queries) 1 December 14th 05 07:53 PM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"