Home > Tips and Tricks > How to join Excel data in Cell

How to join Excel data in Cell

Posted by : Dexter Panganiban on February 10, 2007 | ; Filed Under Tips and Tricks

Objective : To be able to join Text data in Excel cell.

Have you encountered a task in excel where you need to connect the data content of A1,B1,C1 & D1 as shown in the picture. Well it is easy if it is only 1 or two but what if you have a thousand of same task to do?. You just have to use the below formula :

=A1&” “&B1&” “&C1&” “&D1&”" ( Resulting data = The quick brown fox )

The space in between two quotation marks signifies the space of its resulting data. If you put anything in between the two quotation marks it will show up. See below example :

=A1&”-”&B1&”-”&C1&”-”&D1&”" ( Resulting data = The-quick-brown-fox )

and if you are going to do this in repetitive task , Make the formula in Cell E1 and then copy. Hope this helps.

Technorati tags: Excel Tips, Join Excel Data
Related Posts
  • Excel Tricks : Hide Those %&@# Formula Errors
    Errors in Microsoft excel may sometimes occurs while doing calculation, such us multiplying a word to a number, and many more, This post will help you to drop the unwanted characters that will result to errors in calculation, But you have to use this trick with caution. I recommend using this trick ...
  • Excel Tips : How to Make your Worksheet Name To Appear Into the Cell
    If you don't use Microsoft Excel forget just go to my other post :) Question : How to Make your Worksheet name to appear on your Microsoft Excel Sheet ? Answer : You can use the formula shown below, just copy and paste this formula in any of the cell where ou want to Worksheet name to appear. ...
  • Excel Trick : What is the use of $ sign?
    Did you know "$" sign is an important part of excel formula? I would try to teach how you could use this sign. Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 ) See it here Technorati tags: Excel Tricks, Excel Tips, Microsoft...
Related Posts Plugin for WordPress, Blogger...

Incoming search terms:

Enter your email address:

Tags: Excel, excel functions, excel spreadsheet formulas, excel tips, Microsoft Excel Tips

About the author

Dexter is a person that love technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

Sign up for PayPal and start accepting credit card payments instantly.

Interesting Comments

2 Responses to “How to join Excel data in Cell”

  1. Byron on June 18th, 2007 4:13 am

    Hi, Rexted,
    Thanks for the Excel tips! It is amazing how many folks are looking for stuff you probably take for granted. I wanted to share with you an Excel Add-in that a friend of mine introduced me to a few months ago. It’s called ASAP Utilities. (Here is my writeup of it on my own blog: Excel Add-in. This thing has literally hundreds of helpful shortcuts. I was late to the game in starting use it at my company as all of the Excel gurus had been using it a while. You may be already too. But if not, you may want to check it out. I’m not affiliated with them in any way…just blown away by all the cools stuff it does!
    Best regards!
    Byron

    Reply


  2. Rexted on June 18th, 2007 6:05 am

    Thanks for stopping by Byron. You have also a nice site.

    Reply


1 pingsLinks To This Post

  1. Welcome Pacquiao And Marquez Fans » Tech At Hand on March 17th, 2008 5:39 pm

    [...] How to join Excel data in Cell [...]


Leave a Reply




My Sponsors

Help My Father's Kidney Dialysis Expenses

Help in My Father’s Kidney Dialysis by Contributing Articles and/or Being Our Link Builder

Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Categories