Commentary Logo
Japan Island disputes in Southeast Asia    World War III Alarm Anti-Islam video and anti-US sentiment    Skull Say no to brainwashing

       peace and anti-war Israel Iran strike imminent    sanctions as a result of nuclear tests Sanctions on Iran and workarounds    black lightning bolt India's massive blackout

Snapshots of news
Gearheads and mastheads
SHORTCUT TO MAIN SECTIONS & ARTICLES
Home  •  About this site  •  How did we once fight corruption in colonial Hong Kong?
 •  Historical US administrative thoughts  •  USA versus colonial Hong Kong
 •  Anti-corruption review of Nigeria  •  Procurement monitoring in Nigeria
 •  Syndicated news  •  Usman's blog  •  Anti-graft news  •  Socialist news

 Thursday, May 25 2017 3:27am Hongkong Time

Posted May 28, 2012

Back to Blog Index   


3 Ways To Combine/Merge Two Cells Into One In Excel 2010

I was working on Microsoft Excel 2010 and I needed to combine or merge the content in two cells into one. While searching the Internet, I found many methods of doing this so I thought of listing down all the methods here so that it may be useful for everyone to know.

concatenate function in Excel 2010

Using the concatenate function

The concatenate function can be used to combine or merge two or more cells into one. You can use the values of multiple cells to be combined in the resulting cell. Here’s the syntax of concatenate function. This function is available in all versions of Excel including Excel 2010 and 2007.

=CONCATENATE(cell1, cell2, cell3 ..)

Somehow if you want to select a range and try to use the colon (:) operator, concatenate function will not work correctly in case of text.

=CONCATENATE(cell1:cell4)

The above function will not work correctly so you will need to use the syntax that I have specified first.

Using the & operator

& operator can be used as a concatenation operator in Microsoft Excel. The function of & is to combine the values of two cells and display the final value in the resulting cell. Let’s take an example. I have written "technize", "." and "net" in three different cells and I want to combine them in one cell, I will use the following code in the resulting cell:

Cell1 = C1 : technize

Cell2 = C2 : .

Cell3 = C3 : net

resulting cell = C4 : =C1&C2&C3

Using VBA programming

If you want to merge cells using VBA then you can use the following VBA code to do so:

Sub ConcatenateColumns()


		

Back to Blog Index   

© Usman Khurshid. Reproduced with permission of the copyright owner.



RELATED ARTICLES

  15/05   System Level Spell Checkers For Windows
  04/05   Four Ways To Insert/Eject CD-ROM Tray In Windows
  06/03   Control Windows Volume Automatically with These 3 Tools
  18/01   5 Ways to Access Files, Folders and Programs Quickly In Windows
  28/05   3 Ways To Combine/Merge Two Cells Into One In Excel 2010
  01/05   3 Free Tools To Password Protect PDF Files
  29/04   3 Free Portable Tools To Change Creation/Modification Date Of Files And Folders


OTHER CATEGORIES



GAMES


INTERNET


MICROSOFT


SECURITY


SOFTWARE


TIPS

ABOUT THE CONTRIBUTOR

Usman Khurshid is a network consultant who works in a mixed environment of Windows and Linux platforms. He studies about the latest advancements in computer technology and shares his views on this technology blog.

Email Usman at usman {at} technize {dot} com



Commentary and reflection pages by Raymond Cheng, PhD DPA FRSA

  Main • Commentary   Special Foci • Syndicated News | Corruption | Socialism | GuanXi

  Health Related • Traditional Chinese Medicine   Others • OXLL


© 1997-2014 The Commentary, Office of Dr Raymond Cheng. All rights reserved. Copyright of selected news articles, the headlines and logos belongs to the respective entities. Read disclaimer

Digital platform powered by Wyith Limited, Wyith Institute. Wyith Limited and Wyith Institute are associated businesses operated by the Office of Dr Raymond Cheng • Dr Raymond Cheng & Partners Ltd and The Commentary Ltd.

SHORTCUT TO MAIN SECTIONS & ARTICLES
Home  •  About this site  •  How did we once fight corruption in colonial Hong Kong?
 •  Historical US administrative thoughts  •  USA versus colonial Hong Kong
 •  Anti-corruption review of Nigeria  •  Procurement monitoring in Nigeria
 •  Syndicated news  •  Usman's blog  •  Anti-graft news  •  Socialist news

Contact the editor at raymond {dot} cheng {at} kellogg {dot} oxon {dot} org

RESERVED SECTION FOR MEMBERS
The RendezvousBuildersCommentatorsContributorsReadersResearchers
Reflection Pages • Miscellaneous Stuff
The difference between instant evaluation and improving recognition – November 20
Freddy Krueger revisited: Politically correct education? – October 23
From the evaluator's perspective: Justified conclusions and decisions – October 8
Online and distance-learning degrees from the evaluator's perspective – September 25
The moment fake degrees turned recognized and appraised – September 9

Photo credits for top title bar, from left to right: Iza H (Work), Lukasz Gumowski (Blue balls), Marcin Bania (Smiling and naked), Lautaro Gonda (Milan station), Jan Abt (Girl taking a picture), Daniel Tang (Hot switch), Barbara Henry (Moriah reading), Ralf Herrmann (Checkmate II), Marko Roeper (Led #4), Ian Russell (Girl in downtown LA).
Note: Animated GIF graphics and clipart obtained from amazing-animations.com, gifs.net, findicons.com, clker.com and sevenoaksart.co.uk. Sketches, cartoons and other handdrawings courtesy of Alice-the-Artist.

Special Alert! This is *NOT* the American Jewish Committee's Commentary Magazine! Special notice! This is not the American Jewish Committee's Commentary Magazine nor are we in any way affiliated with them. To visit AJC's magazine, please go to commentarymagazine.com instead, thank you for your attention.
Memo with pin Technical memos for members
Receiving using Gmail | Sending using Gmail
0x800ccc0e | 0x800ccc19 | 0x800ccc79

This site is best viewed with Microsoft® Internet Explorer 6.0 or above, minimum 1024x768 16M color-depth resolution. The Commentary Group and its personnel do not endorse external sites and are not responsible for the content of these websites. All external sites will open in a new browser window.




 
COUNT ON THE STATISTICS  100% Towels (c) Daniel Chittka
Photo © Daniel Chittka

This new section contains some interesting statistics in bribe and corruption, please check back for more as we pile up our numbers!

It's statistics time!  Using n-gram: kickback, graft, bribe and corruption - Comparison of their historical occurrences from 1810 to 2009 A.D.

  The word guanxi (collocation) and meanings of bribe: Deeply rooted, disgusting, sad endings

ADVERTISEMENT
Search for a domain name - no obligation!
www.  
 enter a name, word or phrase
 choose an extension
 click go!
LATEST STUFF TO PONDER UPON
Looking for a good book (c) Doug Logan
Photo © Doug Logan
tagged by area of interestBY AREA OF INTEREST
Trends
Pragmatics: Politeness trends from the historical perspective of global trade
Computer mediated communications: Social network – Came riding the waves of amazing coincidences
Analysis
Language acquisition:
A critique on "A corpus driven study of the potential for vocabulary learning through watching movies"

Grammatical analysis: "When a linguist stumbled upon a Buttonwood"
Lexicon and the corpus: "John Sinclair's lexical items – an introduction"
tagged by regionBY REGION • Anything AsiaUS Presence in Asia
Communist ChinaNationalist TaiwanHong Kong and MacauJapanKoreaSingaporeMalaysiaPhilippinesPakistanIndiaAfghanistan0 • Vietnam, Laos, Cambodia, Thailand and MyanmarTimor-Leste and IndonesiaMongoliaNew Zealand and Australia
tagged by topicsBY TOPIC • BiofuelRhino and elephant poachingAmerican movies hit China marketChina Internet censorshipChina's outward FDI opportunitiesGlobal rice yield
GLUCK ON SOCIALISM AND CHINA Asia (c) Robert Churchill
Photo © Robert Churchill

Professor Sidney Gluck (c) Sandi BachomI am honored to have obtained Professor Sidney Gluck's (right) permission to allow me to repost here some of his work and interview related to China and socialism. Professor Gluck is professor emertius at the New School University in New York. A classical Marxist, Gluck has been studying China for 60 years in history and modern development. He has lectured all over the U.S. and still welcomes engagement at the age of 94 – photo © Sandi Bachom

FEATURED ARTICLES

COMING 2014 – COMPUTING CORPUS Active Network Hub (c) Phil Sigin-Lavdanski
Photo © Phil Sigin-Lavdanski

Oh, please do not get me wrong. This new section is not about computers, electronics or any engineering stuff, but rather I am currently constructing a new corpus based on Spectrum, the monthly publication from the Institute of Electrical and Electronics Engineers USA, from July 2007 to date. Having been a member for over 20 years since 1992, I am always fascinated by some of the terms scientists use when they talk about or envision their new inventions or methodologies. How many of them eventually come into practice? Could there be some insights we could possibly derive, from the linguistics perspective?

IMPORTANT NOTICE AND DISCLAIMER

This website is published and designed by
Raymond Cheng, PhD DPA and reflects only his personal views and opinions in his individual capacity. It does not represent the views and opinions of his firm, employer(s), students, etc., and is not in any way sponsored or endorsed by any other thrid parties. Click here to read my full disclaimer
SHARE THIS WEBSITE WITH SOCIAL MEDIA

Share on Twitter  Add to Facebook  Share on LinkedIn  +1 on Google