View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default How Do I Add Commas To Columns And Remove Spaces In Excel??

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