1. 

   Clarity
   

   Member
   Joined: Dec '09
   Posts: 72

   Hi,

   Just as a point of interest as there have been a few posts on Concatenate recently. I tend to use "&" rather than the concatenate formula. eg:

   ="Hello"&" everybody"

   instead of

   =CONCATENATE("Hello"," everybody")

   I haven't come across any issues using it and it seems to work in the same way as CONCATENATE. The only possible issue I can see is other users not being able to understand the formula.

   Does anyone have any thought?

   Cheers,

   Myles

   Posted 3 years ago #
2. 

   Hui
   

   Excel Ninja
   Joined: Jul '09
   Posts: 5,037

   I believe '&' is a throw back to Lotus 123 which Excel has maintained for compatibility

   Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums