Forum Discussion
When will Microsoft Forms be finalized
- Aug 01, 2022
You don't have to use any of the new features of Office 365 Excel. Old functions work just fine. And for this, you do not even need to use an old function (CONCAT). Simply enter the following into D2:
=B2 & " " & C2 & " " & A2
Of course, things get interesting if you want to handle the case where there is no middle name. At a minimum:
=B2 & " " & IF(C2="", "", C2 & " " ) & A2
And then there are all sorts of other special cases to handle.
- darrellaasJul 22, 2017MVP
Agreed Dean_Gross. Changes such as Forms being available, turned on and licensed to users in a tenant, then mysteriously unavailable. I had it working, the tile was available. Now the tile has gone and I can't access it via the direct link to forms.microsoft.com.
John Toews, can you shed some light on the rollout? Is it being retracted from some tenants / regions?
- Jul 22, 2017Agreed @darell this kind of behavior is most unpleasant and strange!
- darrellaasJul 22, 2017MVPJohn Liu helped me discover the issue. If your tenant uses First Release for a select group rather than for the whole organisation, Forms Preview will be unavailable. I had turned on First Release for a select group to hurry the SharePoint Communications site rollout. This "turned off" the Forms Preview that was working in my tenant.