Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,523
- Office Version
- 365
- Platform
- Windows
Some off the top of my head things I would like to see added to XL2016 (would be nice if they could be extended to earlier versions as well).
1) Extend the CONCATENATE function to be able to handle ranges as well as single entries (similar to how I did it in this UDF...Flexible Concatenation Function or even this one... FORMATTED Flexible Concatenation Function). Oh, and change its name to something simpler to type, like maybe JOIN.
2). Add a FIELD function similar to this one... Get Field from Delimited Text String
3) Make the MID function's work like the VBA Mid function so that its third argument is optional (when omitted, it automatically pulls the remainder of the characters in the text).
4) After making a selection of contiguous or non-contiguous cells, give us a method to deselect individual cells from the selection.
5) Extend the VBA Precedents and Dependents properties so that they work across multiple worksheets instead of making us concoct some weird code using the NavigateArrow method coupled with worksheet activations.
6) Give VB a FindAll method so that we do not have to keep constructing multi-line loops in order to move between all cells matching the find's conditions.
I am sure there are tons more, but those come to mind quickly whenever I think about what is missing in Excel.
1) Extend the CONCATENATE function to be able to handle ranges as well as single entries (similar to how I did it in this UDF...Flexible Concatenation Function or even this one... FORMATTED Flexible Concatenation Function). Oh, and change its name to something simpler to type, like maybe JOIN.
2). Add a FIELD function similar to this one... Get Field from Delimited Text String
3) Make the MID function's work like the VBA Mid function so that its third argument is optional (when omitted, it automatically pulls the remainder of the characters in the text).
4) After making a selection of contiguous or non-contiguous cells, give us a method to deselect individual cells from the selection.
5) Extend the VBA Precedents and Dependents properties so that they work across multiple worksheets instead of making us concoct some weird code using the NavigateArrow method coupled with worksheet activations.
6) Give VB a FindAll method so that we do not have to keep constructing multi-line loops in order to move between all cells matching the find's conditions.
I am sure there are tons more, but those come to mind quickly whenever I think about what is missing in Excel.