=AND(G1<"ULT",G1<"ABC",G1<"DEF")
Add as many as you like with comma between
them although there is an upper limit but not
sure what that is.

The limit would be the number of arguments the AND function takes which is
version dependent* or a total formula length of 255 characters. Whichever
occurs first.

Excel 2007 = 255 arguments
All other versions = 30 arguments

--
Biff
Microsoft Excel MVP


"OssieMac" wrote in message
...
Hi Mike,

When applying Data Validation, select then entire range to have the
validation and then apply the validation as if only for the first cell of
the
selection. Excel looks after applying correct formula to remaining cells
in
the selection.

Select the range G1:G50 and then Data Validation - Custom.

Use the following formula for multiple strings to be excluded. (I have
used
3 strings to exclude. Add as many as you like with comma between them
although there is an upper limit but not sure what that is.)

=AND(G1<"ULT",G1<"ABC",G1<"DEF")


--
Regards,

OssieMac