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

concactenate

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

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.