View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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