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