Sep 15 2019 09:50 AM
Sep 15 2019 10:07 AM
Hi,
My guess that the error type is #NAME?
If so, you have to have Excel 2019 or Office 365 to use this function.
If you have an earlier version of Excel, you can use other options as follows:
=A1&" "&B1
=CONCATENATE(A1," ",B1)
Hope that helps