training in excel - catatonate

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

training in excel - Catatonate

resolvedResolved · Low Priority · Version Standard

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?

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

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips


Server loaded in 0.1 secs.