merge adjacent cell data

  • Thread starter Thread starter ROLG
  • Start date Start date
R

ROLG

how do i merge a number of cells in a row so that the numbers in eac
cell will be in that one merged cell?
 
Hi

you can't,
but you can concatenate them into one cell and then delete the others
=A1&B1&C1&D1 etc
will string together the values in cells A1, B1, C1 & D1
you can then copy this cell, choose edit / paste special - values to change
it from a formula to a value and then, if you want, delete the original
numbers

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Best solution to merge multiple Outlook contacts easily 2
Auto Row Height with Wrapped Text in Merged Cells Problem 3
How to subtract a number from a Mergefield? 0
Count with merged cells 2
Why does picking an cell highlight two cells? 1
VBA set thick borders around non empty cells in range 0
How do I repeat a format of 2 merged cells to a number of rows in. 4

Back
Top