I want to take the contents from 4 cells and merge the data to one cell. The
cells are all numbers (the example below is what I'm trying to merge.)


CELL1 CELL2 CELL3 CELL4 Merged cell
1250 0301 140 003 12500301140003

I can use this formula
=CONCATENATE(Cell 1,Cell 2,Cell 3,Cell 4)
But it leaves out the zeros in the merged cell. They're important.

this may work:
=CONCATENATE(T(Cell 1),T(Cell 2),T(Cell 3),T(Cell 4))


Eddie O

"Pete" wrote:

I want to take the contents from 4 cells and merge the data to one cell. The
cells are all numbers (the example below is what I'm trying to merge.)


CELL1 CELL2 CELL3 CELL4 Merged cell
1250 0301 140 003 12500301140003

I can use this formula
=CONCATENATE(Cell 1,Cell 2,Cell 3,Cell 4)
But it leaves out the zeros in the merged cell. They're important.

Nah.
Sure didn't. All I get from that formula is a blank cell. Even formatted
cells to text (assuming that is what the T is for?

"Eddie O" wrote:

this may work:
=CONCATENATE(T(Cell 1),T(Cell 2),T(Cell 3),T(Cell 4))


Eddie O

"Pete" wrote:

I want to take the contents from 4 cells and merge the data to one cell. The
cells are all numbers (the example below is what I'm trying to merge.)


CELL1 CELL2 CELL3 CELL4 Merged cell
1250 0301 140 003 12500301140003

I can use this formula
=CONCATENATE(Cell 1,Cell 2,Cell 3,Cell 4)
But it leaves out the zeros in the merged cell. They're important.

one way:

=TEXT(Cell1,"0000") & TEXT(Cell2,"0000") & TEXT(Cell3,"000") &
TEXT(Cell4,"000")

In article ,
"Pete" wrote:

I want to take the contents from 4 cells and merge the data to one cell. The
cells are all numbers (the example below is what I'm trying to merge.)


CELL1 CELL2 CELL3 CELL4 Merged cell
1250 0301 140 003 12500301140003

I can use this formula
=CONCATENATE(Cell 1,Cell 2,Cell 3,Cell 4)
But it leaves out the zeros in the merged cell. They're important.

Genius!
Thanks. This will save a bunch of work...

"JE McGimpsey" wrote:

one way:

=TEXT(Cell1,"0000") & TEXT(Cell2,"0000") & TEXT(Cell3,"000") &
TEXT(Cell4,"000")

In article ,
"Pete" wrote:

I want to take the contents from 4 cells and merge the data to one cell. The
cells are all numbers (the example below is what I'm trying to merge.)


CELL1 CELL2 CELL3 CELL4 Merged cell
1250 0301 140 003 12500301140003

I can use this formula
=CONCATENATE(Cell 1,Cell 2,Cell 3,Cell 4)
But it leaves out the zeros in the merged cell. They're important.