Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel training vba london - Text Functions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

course excel training vba london - Text Functions

Resolved · Low Priority · Version Standard

Reply Wed 10 Oct 2007, 16:07Delegate Carri said...

Carri has attended:
Excel Advanced course
Powerpoint Introduction course

Text Functions

How to combine two columns of text together in one cell?

For upcoming training course dates see: Pricing & availability

Reply Thu 11 Oct 2007, 10:35Trainer Pete said...

RE: Text Functions

Hello Carri, 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 articles

· How To Use Excel To Track Your Weight Loss
· Microsoft Excel Training: Not Just for Newbies Anymore
· Excel Charts As Easy As Pie
· Customize Your Gridlines And Borders In Excel 2007
· Save time with Microsoft Excel

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips