Combine multiple cells into one cell

  • Thread starter Thread starter Michael Tomasura
  • Start date Start date
M

Michael Tomasura

You can concatenate cells like this

=C10&D10&E10&F10&G10&H10

if you want spaces do this

=C10&" " &D10&" "&E10&" "&F10&" "&G10&" "&H10
 
I need to combine text and numbers from 6 cells into
one cell (same order as cells are in). There are about
250 rows to process. Is there an easy way to do this?

Thanks,

Jim
 
To add to Michael's answer - concantenate as he has shown in to an available
cell and drag down, so that all cells are then concantenated.

Ken
 
Back
Top