Consolidate On Steroids???
Hi Garry,
Am Mon, 19 Feb 2018 13:56:05 -0500 schrieb GS:
=CHAR({100,112,98,111,122,97,114,116,104,64,115,11 9,107,111,46,110,101,116})
CHAR([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])
Square brackets in VBA denotes a range. The following are equivalent:
Range("A1:E1")
[A1:E1]
try:
CHAR({100;112;98;111;122;97;114;116;104;64;115;119 ;107;111;46;110;101;116})
with CONCAT as array formula.
Regards
Claus B.
--
Windows10
Office 2016
|