In the new update I have created a new form and used the calculation field to combine first and 2nd names to make a full name field. However, since the update this field does not insert a space when the calculation is complete as in the screen shot attached.
Can you advise please?
Thanks
Attachments:
You must be
logged in to view attached files.
Just make the formula <first name> + ” ” + <last name>
Neil, it does this because spaces within the formula have no bearing on the result of the calculation. So Leo is correct that you have to explicitly add a space with + ” ” + into your formula to get a space in the result.
Thanks to you both for your help. I was adding in the + when just needed the ” ”
Cheers