Combine multiple cells into one cell

[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

 

[Jim]

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

 

[Ken]

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