Welcome back to our frequent blog of Excel functions from A to Z. Today we look at the CONCAT function.
The CONCAT function
Plus and more users are migrating to the Office subscription model 365 And with that comes great power, good Excel 2016 anyway. Y Some Office versions 365 Excel 2016 They're getting six new features to play with. The rollout began at the end of February 2015. 2016 and continues to this day.
Note I said Some Excel users are getting these new features. To access these features, Must meet one of the following requirements:
- You're an Office subscriber 365 and you have the latest version of Office installed on your PC
- You're using Excel Online
- You're using Excel Mobile
- You're using Excel for Android phones and tablets.
Have Office 2016 Independent is insufficient: Microsoft's push to get everyone on board with the subscription model continues! Even then, The rollout will be done in stages. Office subscriptions 365, Home, Personal or University will be updated before other types and companies find that the new features have been restricted by their IT departments. At the same time, recent discussions about Excel to suggest that PCs may be getting new features before Macs. etc.
CONCAT is one of the new features available in this Excel 2016 New Age.
This feature replaces the CONCATENAR function (See our next feature blog). The CONCAT The feature combines text from various ranges and / or text strings:
CONCAT (text1, [text2],…)