concactenate

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Concactenate

Concactenate

resolvedResolved · Low Priority · Version 2003

Amanda has attended:
Excel Advanced course

Concactenate

Are there chapters covered in the disc manual?

RE: concactenate

Dear Amanda

Thank you for attending Excel Advanced course. I hope you enjoyed the course and are finding the topics covered during the training useful.

I am not sure if the CD that you received with eth course manual contain the Concatenate function but it is fairly straight forward to use.

Please find an uploaded Excel File for your reference.

Let me take you through step by step how I managed to use Concatenate function.

Step 1: Type the first and last names in cell range A2:B5.
Step 2: Click on cell C2 and use the fx button on the formula bar
Step 3: Type Concatenate in the search for a function box and then press the enter key
Step 4: Select the concatenate from the select a function box and press OK button
Step 5: In the Concatenate dialog box for Text 1 click on the cell A2
Step 6: In the Text 2 box type in

Attached files...

Concatenate.xls


 

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips


Server loaded in 0.09 secs.