excel programming vba - Text function

The UK's most regular instructor-led training courses.
Training information: excel programming vba · Microsoft excel training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Text function

Stephanie has attended:
Powerpoint Advanced course

by - delegate Stephanie [1 post] (2007 Sep 11 Tue, 15:33) Reply

How do you put 2 columns of data to appear as one?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: text function

by - trainer Anthony gold contributer [113 posts] (2007 Sep 24 Mon, 18:07) Reply

Hi Stephanie. Let's assume there's data in cell A1 and cell B1. To combine the contents of those cells into cell C1 you need the formula "=A1 & B1". You can then use that formula to populate the rest of the column.

Hope this helps,

Anthony

· How Small Businesses Profit from Outside Excel Training
· Basic Excel Training
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Fun Things I've Done With Excel

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips