| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging info from 5 cells to 1
I have a number 21-/A/-525-/E/-0001 the / represent the cells, I want it in
one cell to look like 21-A-525-E-0001. We I concatenate or use & it removes the dashes and turns 0001 into 1. Does anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
| Merging Cells and autofit | Excel Discussion (Misc queries) | |||
| Excel-cannot view info placed in cells | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
Threaded Mode
