Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Catatonate

	98.1 % recommend us
	More live stats...

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

Training information:

training in excel - Catatonate

Resolved · Low Priority · Version Standard

Reply Thu 26 Jul 2007, 14:15Delegate Doug said...

Doug has attended:
Excel Intermediate course
Excel Advanced course

Catatonate

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 26 Jul 2007, 16:33Trainer Richard said...

RE: catatonate

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

Excel articles

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How To Pick The Best Chart Type In Excel
· Where Are The Form Controls In Different Versions Of Excel
· Microsoft Excel Features and Functions for Accountants
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips