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