| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel needs to expand text concatenation capability
I would love to be able to concatenate any non-blank entries from a list.
Unfortunately, I can't seem to do that other than manually entering each cell reference into a CONCATENATE() command. What I'd love to see, in order of preference, is: CONCATENATE(A1:A100) - Pretty obvious CONCATENATEIF(Range,Criteria,Concat_Range) - Like SUMIF, but concatenates DCONCATENATE(Database,Field,Criteria) - Like DSUM, but concatenates |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| html to excel | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
| Shortcut file fails to open | Excel Discussion (Misc queries) | |||
| pivotcell object to excel 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
