Data Validation - Validating TXT!!!??? :(

Galvin

New Member
Joined
Apr 19, 2002
Messages
1
I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Try this:

On a separate sheet to where you want the validation to occur, type in A B and C in separate cells. Select those cells, click on Insert-Name- Define and enter a name in the top box (say myList) and click on 'Add'. Go onto the sheet where you want the data to be validated, select the cells and click on Data-Validation, change the 'Allow' to List and in the Source box enter =myList. HTH.
 
Upvote 0
On 2002-04-20 10:09, Galvin wrote:
I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike

Hi Galvin:
In addition to what Mudface suggested, you could also use a formula for validation ...

1) Click on A1 then highlite the cells you want to validate
2)DATA|VALIDATION|SETTINGS|Allow|Custom|Formula

3) enter the following formula in the formula box

=or(A1="A",A1="B",A1="C")

HTH
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top