Merging data to one cell from many

[Guest]

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.

 

[Guest]

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


Eddie O

 

[Guest]

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?

 

[JE McGimpsey]

one way:

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

 

[Guest]

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