Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel courses - what concatenate and does

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - What is concatenate and how does it work?

excel courses - What is concatenate and how does it work?

ResolvedVersion 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

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.