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

[Guest]

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

 

[Guest]

Try concatenating them together

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

HTH,

Barb Reinhardt

 

[Guest]

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

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

 

[Pete_UK]

If the date is in Excel date format you will probably end up with a
number. If so try this:

=TRIM(A1&","&B1&","&TEXT(C1,"dd/mm/yyyy"))

Hope this helps.

Pete