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

Hi Garry,

Am Mon, 19 Feb 2018 17:21:51 -0500 schrieb GS:

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

2016 (Office 365)


Regards
Claus B.
--
Windows10
Office 2016

Hi Garry,

Am Mon, 19 Feb 2018 17:21:51 -0500 schrieb GS:

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

2016 (Office 365)


Regards
Claus B.

Nice! Adds to my list of args FOR subscribing...

--
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:21:51 -0500 schrieb GS:

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

2016 (Office 365)


Regards
Claus B.

Ok, I installed 2016 and getting same results, no CONCAT function here either!

--
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 22:17:57 -0500 schrieb GS:

Ok, I installed 2016 and getting same results, no CONCAT function here either!

have a look:
https://support.office.com/en-us/art...rs=en-US&ad=US


Regards
Claus B.
--
Windows10
Office 2016

Hi Garry,

Am Mon, 19 Feb 2018 22:17:57 -0500 schrieb GS:

Ok, I installed 2016 and getting same results, no CONCAT function here
either!

have a look:
https://support.office.com/en-us/art...rs=en-US&ad=US


Regards
Claus B.

Ok, only available to 365 subscribers. I'm subscribed but haven't signed in my
2016 install yet. Thanks for the help...

--
Garry

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