Excel CONCATENATE Function

Excel CONCATENATE function is one of the best time saving Excel function. You must have seen people copying the value from one cell and then adding it to next cell one by one but the CONCATENATE formula can do it within seconds. The word concatenate is just another way of saying “to combine” or “to join together”. The CONCATENATE function allows you to combine text from different cells into one cell. CONCATENATE function could be used to combine two plain strings or values of cells. To join strings we use & symbol in between of two strings/cell references.

How to Concatenate Text

Example

In our first example we will use plain strings to concatenate. Let’s assume we have following two strings, first name and last name.

String 1: John

String 2: Mccallum

Formula: =CONCATENATE(“John”&”Mccallum”)

Result: If you will copy and paste above formula in an Excel cell, this will return JohnMccallum which is practically incorrect because first name and second name should have space. Let try to concatenating strings with space between two strings:

Formula: =CONCATENATE(“John”&” “&”Mccallum”)

Now we have perfect output: John Mccallum

127 thoughts on “Excel CONCATENATE Function

  1. Howdy just wanted to give you a quick heads up and let you know a few of the images aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same results.|

  2. I just couldn’t depart your web site before suggesting that I actually enjoyed the usual info an individual supply to your visitors? Is going to be again frequently in order to inspect new posts.

  3. I don’t even know how I ended up here, but I thought this post was great. I don’t know who you are but certainly you are going to a famous blogger if you aren’t already 😉 Cheers!|

  4. I just could not depart your website prior to suggesting that I actually loved the standard info a person supply for your visitors? Is going to be again often in order to check up on new posts|

  5. I intended to post you one little remark just to give thanks the moment again over the pleasing secrets you’ve shared on this site. It is so extremely generous of people like you to deliver openly all that many of us could possibly have sold as an electronic book to help make some bucks for themselves, and in particular considering the fact that you could have tried it if you considered necessary. Those pointers additionally served as the great way to understand that other individuals have the same desire just as my own to figure out great deal more on the topic of this matter. I know there are lots of more fun situations in the future for people who take a look at your website.

  6. My wife and i have been absolutely lucky when Emmanuel could deal with his studies using the ideas he received from your very own weblog. It is now and again perplexing to simply happen to be freely giving tactics which a number of people may have been trying to sell. Therefore we fully grasp we need the website owner to give thanks to because of that. These explanations you made, the simple website menu, the relationships your site help instill – it’s got mostly wonderful, and it’s really letting our son and our family imagine that this situation is fun, and that is rather pressing. Thanks for the whole thing!

  7. Excellent goods from you, man. I’ve understand your stuff previous to and you are just too magnificent. I actually like what you have acquired here, really like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it wise. I can’t wait to read much more from you. This is actually a terrific site.

  8. Greetings I am so happy I found your webpage, I really found you by mistake, while I was looking on Yahoo for something else, Anyways I am here now and would just like to say cheers for a fantastic post and a all round entertaining blog (I also love the theme/design), I don’t have time to read it all at the minute but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the fantastic jo.|

  9. Generally I do not read article on blogs, however I would like to say that this write-up very compelled me to check out and do so! Your writing style has been surprised me. Thank you, quite nice article.|

  10. Thank you for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our area library but I think I learned more clear from this post. I’m very glad to see such magnificent information being shared freely out there.

  11. Have you ever considered writing an ebook or guest authoring on other blogs? I have a blog based upon on the same information you discuss and would love to have you share some stories/information. I know my subscribers would value your work. If you’re even remotely interested, feel free to send me an e-mail.|

  12. Hello, i think that i saw you visited my weblog thus i came to “return the favor”.I’m attempting to find things to enhance my website!I suppose its ok to use a few of your ideas!!

  13. I do believe all of the ideas you’ve introduced to your post. They are very convincing and can certainly work. Nonetheless, the posts are too brief for beginners. Could you please prolong them a little from next time? Thank you for the post.

  14. Keep up the excellent work , I read few blog posts on this internet site and I believe that your site is very interesting and has got bands of superb info .

  15. I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz reply as I’m looking to construct my own blog and would like to find out where u got this from. cheers|

  16. Generally I do not learn article on blogs, however I would like to say that this write-up very compelled me to check out and do so! Your writing taste has been surprised me. Thanks, quite great article.

  17. I have been surfing on-line more than 3 hours as of late, yet I never discovered any attention-grabbing article like yours. It is pretty value enough for me. Personally, if all webmasters and bloggers made just right content as you probably did, the net will be much more helpful than ever before. “When there is a lack of honor in government, the morals of the whole people are poisoned.” by Herbert Clark Hoover.

  18. My brother recommended I would possibly like this web site. He used to be totally right. This put up actually made my day. You can not believe simply how much time I had spent for this info! Thanks!|

  19. A person essentially help to make severely posts I might state. That is the first time I frequented your web page and thus far? I amazed with the analysis you made to create this actual put up extraordinary. Wonderful task!

  20. Hi, Neat post. There’s a problem with your website in web explorer, would test this… IE nonetheless is the market chief and a huge portion of folks will omit your magnificent writing because of this problem.

  21. Heya i’m for the first time here. I found this board and I in finding It really helpful & it helped me out much. I am hoping to give one thing back and aid others such as you helped me.|

  22. We are a group of volunteers and starting a new scheme in our community. Your website provided us with valuable info to work on. You’ve done an impressive job and our entire community will be thankful to you.

  23. Hello there! Would you mind if I share your blog with my twitter group? There’s a lot of people that I think would really appreciate your content. Please let me know. Many thanks|

  24. obviously like your web-site however you need to check the spelling on several of your posts. A number of them are rife with spelling issues and I to find it very troublesome to inform the reality then again I will certainly come again again.

  25. I’ve been surfing online greater than 3 hours nowadays, but I never discovered any interesting article like yours. It’s beautiful worth enough for me. In my opinion, if all web owners and bloggers made good content as you probably did, the web will likely be much more useful than ever before.|

  26. It’s really a nice and helpful piece of information. I am glad that you simply shared this useful info with us. Please keep us up to date like this. Thanks for sharing.

  27. You really make it seem so easy with your presentation but I find this topic to be really something that I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

  28. Hiya very nice blog!! Guy .. Excellent .. Amazing .. I will bookmark your web site and take the feeds also…I am glad to find numerous helpful info here in the post, we’d like work out extra techniques in this regard, thank you for sharing.

  29. You are my aspiration , I own few web logs and very sporadically run out from to post .I believe this site has some real superb info for everyone. “I prefer the wicked rather than the foolish. The wicked sometimes rest.” by Alexandre Dumas.

  30. Very good blog! Do you have any suggestions for aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally confused .. Any recommendations? Appreciate it!|

  31. Hello there! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My website looks weird when viewing from my iphone4. I’m trying to find a theme or plugin that might be able to correct this issue. If you have any recommendations, please share. Thanks!|

  32. Thanks on your marvelous posting! I quite enjoyed reading it, you’re a great author. I will make sure to bookmark your blog and definitely will come back someday. I want to encourage you to ultimately continue your great job, have a nice afternoon!|

  33. Its superb as your other posts : D, thanks for putting up. “There’s no Walter Cronkite to give you the final word each evening.” by William Weld.

  34. I feel this is one of the most vital information for me. And i am glad reading your article. However want to remark on few general issues, The web site taste is wonderful, the articles is in point of fact excellent : D. Excellent task, cheers|

  35. After I originally left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now each time a comment is added I receive four emails with the same comment. Perhaps there is an easy method you can remove me from that service? Many thanks!|

  36. My brother suggested I would possibly like this web site. He was once totally right. This publish actually made my day. You can not imagine simply how a lot time I had spent for this information! Thank you!|

  37. hey there and thank you for your information – I have definitely picked up anything new from right here. I did however expertise several technical points using this website, since I experienced to reload the website a lot of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but sluggish loading instances times will sometimes affect your placement in google and can damage your high quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for much more of your respective interesting content. Make sure you update this again soon.|

  38. Hey there, I think your blog might be having browser compatibility issues. When I look at your blog site in Chrome, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, awesome blog!|

  39. Hello there, just became alert to your blog through Google, and found that it is truly informative. I am going to watch out for brussels. I will appreciate if you continue this in future. Numerous people will be benefited from your writing. Cheers!

  40. I do trust all the concepts you’ve introduced on your post. They are very convincing and will definitely work. Nonetheless, the posts are very brief for newbies. May you please extend them a bit from next time? Thank you for the post.|

  41. Hey there! Someone in my Myspace group shared this website with us so I came to check it out. I’m definitely loving the information. I’m book-marking and will be tweeting this to my followers! Fantastic blog and superb style and design.|

  42. Hi, I think your website might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!|

  43. I must point out my respect for your kindness for men and women that have the need for guidance on in this concern. Your very own dedication to getting the solution all-around turned out to be remarkably insightful and have usually helped ladies just like me to get to their aims. This important hints and tips indicates much a person like me and substantially more to my office colleagues. Thanks a ton; from each one of us.

  44. You really make it seem so easy with your presentation but I find this matter to be really something which I think I would never understand. It seems too complex and very broad for me. I am looking forward for your next post, I’ll try to get the hang of it!|

  45. Greetings from Ohio! I’m bored to tears at work so I decided to check out your blog on my iphone during lunch break. I enjoy the knowledge you present here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my mobile .. I’m not even using WIFI, just 3G .. Anyhow, amazing blog!|

  46. Great weblog right here! Also your website loads up fast! What web host are you using? Can I am getting your affiliate link to your host? I wish my web site loaded up as fast as yours lol|

  47. Its like you learn my mind! You appear to grasp a lot about this, like you wrote the guide in it or something. I feel that you can do with a few to drive the message house a little bit, however instead of that, this is great blog. A fantastic read. I’ll certainly be back.|

  48. Good day! I could have sworn I’ve been to this site before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!|

  49. I am curious to find out what blog system you are utilizing? I’m having some small security issues with my latest site and I would like to find something more secure. Do you have any recommendations?|

  50. Hi, i feel that i saw you visited my weblog thus i came to go back the favor?.I’m trying to in finding issues to enhance my website!I guess its ok to make use of a few of your ideas!!|

  51. Thanks for the sensible critique. Me & my neighbor were just preparing to do some research about this. We got a grab a book from our area library but I think I learned more from this post. I’m very glad to see such magnificent info being shared freely out there.

  52. Somebody essentially lend a hand to make severely articles I’d state. This is the very first time I frequented your web page and up to now? I amazed with the analysis you made to make this particular put up incredible. Magnificent job!

  53. I have been absent for some time, but now I remember why I used to love this site. Thanks , I will try and check back more frequently. How frequently you update your web site?

  54. You really make it seem really easy along with your presentation but I find this matter to be really one thing that I feel I might by no means understand. It sort of feels too complicated and very large for me. I’m having a look ahead on your subsequent post, I¡¦ll try to get the dangle of it!

  55. Thank you for another informative blog. Where else may I am getting that type of information written in such an ideal approach? I’ve a mission that I’m just now running on, and I have been at the glance out for such info.

  56. Hi! Someone in my Facebook group shared this site with us so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Excellent blog and excellent style and design.|

  57. Hey! This post couldn’t be written any better! Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this write-up to him. Fairly certain he will have a good read. Thank you for sharing!|

  58. Excellent post. I was checking continuously this blog and I’m impressed! Very helpful information particularly the last part 🙂 I care for such info a lot. I was looking for this certain information for a long time. Thank you and best of luck.

  59. Hey there! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having problems finding one? Thanks a lot!|

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2017/03/24/excel-concatenate-function
YouTube49
YouTube