Not sure whether this is what you are looking for. Try the below in cell C2
with your text value in A2 and B2...

=IF(AND(SUM(COUNTIF(A2,{"AM","PM"})),
SUM(COUNTIF(B2,{"scheduled","unscheduled","tardy"} ))),A2&"-" &B2,"")

--
Jacob (MVP - Excel)


"gridenbaugh" wrote:

I want to know if it is possible to add content from two columns into one
cells with multiple criteria. example. column 1 criteria is either AM or PM
and I have to beable to distinguish between the two. Column 2 is scheduled,
unscheduled, tardy, etc., column 2 has like seven different criteria. Is
there a way of doing this?