microsoft excel training day courses near kent - columns text
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Wed 17 Oct 2007, 15:21Delegate Lauren said...

Lauren has attended:
Excel Advanced course

Columns, text

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

For upcoming training course dates see: Pricing & availability

replyReply Wed 17 Oct 2007, 16:47Trainer Amanda said...

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

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard