training in excel - Catatonate

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

Resolved · Low Priority · Version Standard

Catatonate

Doug has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Doug [3 posts] (2007 Jul 26 Thu, 14:15) Reply

I need to suffix a long range of data with, for instance -h on every cell. I've been told I need to use the format catatonate and paste special, but I'm stuck. Can you help please?

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: catatonate

by - trainer Richard platinum contributer [813 posts] (2007 Jul 26 Thu, 16:33) Reply

Hi Doug

So if you have your data in column A for example, and then have the suffix -h in column B, you can use the column C to create the joined value.

Use this formula
=CONCATENATE(A1,B1)

The value in column C will be a formula, so you must make sure that you copy the column and then Right click PAST SPECIAL > VALUES to convert the formua to actual data values.

Regards

Richard