98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - What is concatenate and how does it work? | Excel forum
excel courses - What is concatenate and how does it work? | Excel forum
Resolved · Low Priority · Version Standard
Sean has attended:
No courses
What is concatenate and how does it work?
What is Concatenate and how does it work?
RE: What is Concatenate and how does it work?
Hi Sean
Thank you for your question.
The Concatenate function is designed to join text strings together, for example, if you had a person's first name in say cell A1 and their last name in cell B1, you could put the Concatenate function into cell C1 to join the first and last name together =concatenate(a1,b1). If you want a space between the words, use =CONCATENATE(A1," ",B1).
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |