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

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

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

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

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

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

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

On Jul 6, 1:42 pm, JMay wrote:
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- Hide quoted text -

- Show quoted text -