excel courses - what concatenate and does

AI Training: For Busy Decision Makers & Professionals Book now

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips


Server loaded in 0.14 secs.