| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Merging data to one cell from many
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
| merging and formating data | New Users to Excel | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
Threaded Mode
