On 2/18/2018 5:56 PM, GS wrote:
....

-this will be a back&forth situation and so you may want to use email
for direct exchange rather than posting numerous download links here.
....

I'm working on cleaning up a version this AM...I've got until noon
budget meeting -- if you visit before then, send me an e-mail at the
result of

=CHAR({100,112,98,111,122,97,114,116,104,64,115,11 9,107,111,46,110,101,116})

if CHAR would operate on the array instead of just the first element in
the array (I'm sure there's a way to do this in Excel it would just be

CHAR([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])

in Matlab :)

--

On 2/19/2018 9:51 AM, dpb wrote:
....

CHAR([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])

in Matlab :)


Actually

char([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])

<VBG

--

On 2/18/2018 5:56 PM, GS wrote:
...

-this will be a back&forth situation and so you may want to use email for
direct exchange rather than posting numerous download links here.
...

I'm working on cleaning up a version this AM...I've got until noon budget
meeting -- if you visit before then, send me an e-mail at the result of

=CHAR({100,112,98,111,122,97,114,116,104,64,115,11 9,107,111,46,110,101,116})

if CHAR would operate on the array instead of just the first element in the
array (I'm sure there's a way to do this in Excel it would just be

CHAR([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])

in Matlab :)

Square brackets in VBA denotes a range. The following are equivalent:

Range("A1:E1")
[A1:E1]

--
Garry

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

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

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

Hi Garry,

Am Mon, 19 Feb 2018 17:08:31 -0500 schrieb GS:


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...

if you enter the CONCAT formula with CTRL+Shift+Enter you get the whole
string.


Regards
Claus B.
--
Windows10
Office 2016

Hi Garry,

Am Mon, 19 Feb 2018 17:08:31 -0500 schrieb GS:


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...

if you enter the CONCAT formula with CTRL+Shift+Enter you get the whole
string.


Regards
Claus B.

Not happening in v11 so I'll try v2010...

--
Garry

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

Hi Garry,

Am Mon, 19 Feb 2018 17:08:31 -0500 schrieb GS:


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...

if you enter the CONCAT formula with CTRL+Shift+Enter you get the whole
string.


Regards
Claus B.

Not happening in v11 so I'll try v2010...

Same result! What version are you using that has a function named "CONCAT" as
my versions only have CONCATENATE?

--
Garry

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