Microsoft Access Office VB VBA Help and Examples
           

How to Join Text in Excel

I often get asked "How do I join two cells in Excel?", for example cell A1 contains someone's first name (i.e. Brian) and cell B1 contains someone's last name (i.e. Snodgrass). How do you get their full name into cell c1.

the answer lies with the & character. This joins (technically known as concatenation) two cells (or values) together. So the formula we would enter in cell C1 would be:

=A1&B1

though this would give the two names joined together without a space between E.G. BrianSnodgrass. If you want a space you just need to join one in surrounded by " " like this:

=A1& " " & B1

which gives Brian Snodgrass

Not only spaces can be placed between quotes, but any text you like so you could build a formula like this:

="The hero of the story is: " & A1& " " & B1

which gives The hero of the story is Brian Snodgrass.

Complex descriptions can be built using & to join text and "" to show text we want to appear on the spreadsheet. Try it out for yourself.

Chris Shepherd

 
HOME   SEARCH SITE   PRIVACY POLICY   CONTACT
The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.