| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenate
When using concatenate if I have cells that are empty in
that row how can I disregard including the empty cell, without typing function in manually for each row ? Example: Col 1 Col 2 Col 3 Col 4 Col 5 Dan Dave Paul Sue Function I use is =CONCATENATE(A1,",",B1,",",C1,",",E1,",",) Results I receive a Dan,,Dave,Paul, Sue Like to see: Dan, Dave, Paul, Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| UDF to evaluate result of concatenate() with additional arg. | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| Concatenate two halves of a phone number | Excel Worksheet Functions | |||
Threaded Mode
