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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Text functions

microsoft.excel.courses.in.london - Text functions

ResolvedVersion Standard

Wed 10 Oct 2007, 16:07 Delegate Donna-marie said...

Donna-marie has attended:
Excel Intermediate course
Excel Advanced course

Text functions

How to combined two colomns of text together in one cell?

Thu 11 Oct 2007, 10:34 Trainer Pete said...

RE: Text functions

Hi Donna-Marie, Thank you for your question, to undertake this action you will need to use the Concatentate function. Assuming that you wished to combine data from cell B4 and C4 you can use the following function in a new cell (ie A4) =CONCATENATE(B4," ",C4), note the " " space between the two cell references, this is necessary to separate the two text items.

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft.excel.courses.in.london - Text functions

Text functions

RE: Text functions

Excel articles

Excel tip:

Customize the toolbar in Excel 2010