merging cells together but keeping all data from the cells
 

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
--
Pete

merging cells together but keeping all data from the cells
 

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

"Pete C" wrote:

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
--
Pete

merging cells together but keeping all data from the cells
 

You can use a formula something like this...

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

Jim Thomlinson


"Pete C" wrote:

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
--
Pete

merging cells together but keeping all data from the cells
 

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)

"FSt1" wrote:

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

"Pete C" wrote:

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
--
Pete