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.

It returns the 1st character only. I did it w/VBA using the space as a
delimiter to dump the string into an array. Child's play from there...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion