You may need to further refine Barb's suggestion for any excess "spaces" by
using:

=TRIM(A1) & ","&TRIM(B1) & "," & C1




"Barb Reinhardt" wrote:

Try concatenating them together

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

HTH,

Barb Reinhardt

"zeel" wrote:

How Do I Add Commas To Columns And Remove Spaces In Excel??

I need to create lists with the use of 3 columns, i.e., first name, last
name, date
so that it ends up like below when I select all three columns and then copy
and
paste to a text editor like Word Pad ...

first-name,last-name,date
first-name,last-name,date
first-name,last-name,date
first-name,last-name,date


Thank You!

Zack
www.zeel.biz