microsoft excel training day courses near kent - columns text

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Columns, text

microsoft excel training day courses near kent - Columns, text

resolvedResolved · Low Priority · Version Standard

Lauren has attended:
Excel Advanced course

Columns, text

How do you put two columns of text together in one column?

RE: Columns, text

Hi Lauren

Thank you for your question.

You should be able to use the CONCATENATE function to do this. For examle if column A contains first names and column B contains last names, you can display the full name in column C by entering the following:

=concatenate(A1," ",B1)

This will combine what's in cell A1 with what's in cell B1 with a space to separate them.

Amanda


 

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips


Server loaded in 0.09 secs.