Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick # 9: Join 2 Cells into 1

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
31,839
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 3, 2008

Excel! See how to take two columns of data and join them into one column! This process is called Concatenation. And we will use the join operator "&" to create a Text formula! Yes that is right, formulas are not just for numbers anymore! Also, see how to double click the fill handle to copy a formula down quickly.

  • likes, 2 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Awesome video!! Easiest to understand!

  • @yiwsg , I am glad that you liked it!

  • thanks you awesome !!!

  • @d0n0n0n , I am glad that it helped!

  • oh my god, I've spent hours today trying to figure out what you ust showed me in 2 minutes. Thank you!!!!!

  • You are welcome!!!!

see all

All Comments (21)

Sign In or Sign Up now to post a comment!
  • great help.. 

  • how do you take a list of data (which is 10 pages long) and that is one column and place them into two columns.?

  • @ExcelIsFun Awesome. Thanks a million for yout help

  • Here are a few videos that may help:

    Excel Magic Trick 292: Reverse Last & First Name Tricks

    Excel Magic Trick #192: Extract Middle Name Text To Column

    Highline Excel Class 13: Text functions & AMPERSAND

    Excel Magic Trick #190: Rearrange First Last Name w Formula

    Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

    Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more