Posts

Posted on

Add an email hyperlink to an Excel Worksheet

Hyperlinks can add links to an Outlook email address to your Excel worksheet.  Here is how to do it.

In the cell you wish to add the email address, go to the Insert tab, and select the hyperlink button

hyperlink-button-excel-courses-in-london

Type your preferred text into the cell (this saves space as email address are long).  This will be the text the user will click on to access the email address.

Right-click on this cell and click on Hyperlink. This will open  the Insert Hyperlink dialog box.  Click the E-Mail Address button at the bottom left side.

email-address-excel-training-in-london
Link to the email address from here.

Type the email address into the Address field and click OK.

Now you can add a screen tip by clicking on the screen tip button.

screentip-excel-training-in-London
the screentip button.

Add the text you want to appear in the dialogue box, and then click ok.

hyperlink-and-screentip-excel-training-in-London

Here is the hyperlink in place. The text shows “go”, and the screen tip “Sam’s email” appears when the cursor hovers over the cell.

excel courses in London

Posted on

How to separate names in Excel contact lists for mailmerges

If you use mailmerge in Word, often the source of contact details comes from Excel.  And there are times when you inherit contact details from another project or colleague, and the names may not be separated.

This can be a heart-sink moment as you need to separate each name individually.  Argh…this is going to take hours….or in the style of a panto…”oh no it doesn’t!”

How to separate names in Excel – Text to Columns

This is when Excel can save you hours, and possibly even days…you can separate names using Text To Columns.

Here is a seasonal list of names I need to separate

Names-to-change-excel-training-courses
List of a few names that need to be separated before I can mail merge.

In Excel then you can separate the names using the Text to Columns feature on the Data tab.

1.First insert 2 blank columns to the right of your Names column.

insert-columns-excel-training-columns
You will need two columns for your sort to work.

2. Highlight the names in column A and then go to the Data tab, and select Text to Columns.

data-tab-excel-training-courses
The Text to Columns button is on the Data tab, in the Data Tools
dialogue-box-excel-training-courses
To split the names, you need to use the space between the first name and surname, and the result will be shown in the small preview screen

In the dialogue box, select Delimited.

3. Click on space as the first names and surnames are separated by a space.

4. Choose a destination cell at the top of the first inserted column. In our example, we want to use the adjacent cells in column B and C.

destination-cells-excel-training-courses
Use your blank columns as the destination cells

5. Press ok.   The data will then be broken up where ever a space occurs.

sorted-names-excel-training-courses
Sorted!

This technique is included in our Excel training courses and can help you with your Word and Excel work.