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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You may need to further refine Barb's suggestion for any excess "spaces" by
using:

=TRIM(A1) & ","&TRIM(B1) & "," & C1
 
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
 
Back
Top