microsoft.excel.courses.in.london

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

Resolved · Low Priority · Version Standard

Text functions

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

by - delegate Donna-marie [1 post] (2007 Oct 10 Wed, 16:07) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Text functions

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 10:34) Reply

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.

· Features of Microsoft Excel that assist in Analysis of Financial Data
· How to check for and reduce errors in Microsoft Excel
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Rate this page: