Excel 2007 : move data from 3 cells to one cell separate with commas

How do I move data from 3 separate cells into one cell and separate with commas.
thanks,
melanie

Can you be really specific. Eg- Formulas>Insert Function>...

Thank you for your answer- I still dont know where to put that function or how to make it work. sorry- still learning.
Thank you!!

Originally Posted by NBVC

use Concatenate() or &

e.g.

=CONCATENATE(A1,",",B1,",",C1)

or

=A1&","&B1&","&C1

Awesome!! Thanks! I have just one more if you have time.

I want to do a filter so it retains the whole row that has a given search term in it.

Originally Posted by NBVC

I have assumed that the 3 cells you want to concatenate are in A1, B1 and C1, respectively.

just type one of the formulas in the cell where you want the result to be... change A1, B1 and C1 to match the cell you want to concatenate together.

But i want it to find and filter every and any instance of a word though out the whole spreadsheet. It used to be some sort of "file contains" formula but i dont know how to do it in 2007.

Originally Posted by NBVC

Data|Filter|Autofilter, then select from the dropdown at the top of the column of interest.