You can split your existing data with Data/ Text to Columns/ Delimited:
Comma
--
David Biddulph


"JSnow" wrote in message
...
Thanks for the formula, Dave. I prolly should have used two columns but
we've already got over 250 rows of data entered, and i'm not starting over
on
this.

I'll give this a try.

"Dave Peterson" wrote:

You could use data|validation with a custom formula like:

=ISNUMBER(SEARCH(",",A1))

But what about Cher and Madonna? <vbg

If I were setting this up, I would use two (or more) columns. One
dedicated to
the first name and one dedicated to the last name.

It could make further processing much more simple.

JSnow wrote:

I would like to 'police' some of the content my users enter. They're
supposed to enter names thusly: Last, First. However, some are
entering
First Last.

Is there a way to have an alert pop-up if no comma is detected in the
cell?
Excel's help notes on data validation are surpisingly thin.

I'm using column C starting with row 3 and continuing till 200 or son.

Thanks gang.

--

Dave Peterson