merging cells together but keeping all data from the cells

[Pete C]

I have three cells in a row:

cell1= table
cell2=,
cell3=book

I want to try to merge the three cells together so that I get one cell;
table,book.

How and can I do this?

I actually tried copying and pasting the cells out into notepad/wordpad but
there were spaces between the table, comma and book, something I do not need.

Thanks immensely

 

[FSt1]

hi
use a helper column with formula
=A1 & B1 & C1
or
=A1 & "," & C1
copy down.
copy the helper column formulas and paste special values over the data in
A1. delete other columns including helper column.

Regards
FSt1

 

[Jim Thomlinson]

You can use a formula something like this...

=A1 & B1 & C1
Where your info is in those cells...

 

[SSG QuarterMaster]

or you can try this formula in the cell where you want things combined;

=concatenate(a1,b1,c1)

or disregartd the cell with a comma and type

=concatenate(a1,", ",c1)