merging cells together but keeping all data from the cells

  • Thread starter Thread starter Pete C
  • Start date Start date
P

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
 
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
 
You can use a formula something like this...

=A1 & B1 & C1
Where your info is in those 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)
 
Back
Top