| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Indirect, Concatenate, & ?
I have a column of data ("Original") that I added a comma to in the adjoining
column: Original Added Comma I6680 I6680, M1121 M1121, B0265 B0265, E0003 E0003, X6126 X6126, M2686 M2686, I would like to have a single cell look like this: I6680,M1121,B0265,E0003,X6126,M2686....... I have have successfully done this by =B1&B2&B3&B4&B5&B6&B7&B9&B10... Is there an easier way than having to manually typing that formula??? TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate in Pocket Excel | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Threaded Mode
