Add Emoji or Symbol - Windows 10

john lilleystone • March 14, 2020

Add an emoji or symbol into your documents

Did you know that Windows 10 has a built in library of emoji's and Symbols?

Have you ever wanted to insert a Euro symbol € or half symbol ½ into an email/word doc/blog post? Windows 10 has a built in list to choose from - just hold down the Windows key on your keyboard and press the . (period) or ; (semicolon) and a window will appear with a list.

Just double click on the one you want and it will insert it into your application. Give it a try! It's easy.
By John Lilleystone January 21, 2021
Remove whitespaces in Excel using the TRIM function.
excel iferror error alternate result
By john lilleystone April 11, 2020
Replace ugly Excel errors returned by a formula with something more appropriate and pleasing to the eye.
excel transpose
By john lilleystone March 14, 2020
Transpose and paste a vertical column of data horizontally into a row
edit hyperlink
By john lilleystone March 14, 2020
Edit a hyperlink in Outlook 2016
sparklines
By john lilleystone March 1, 2020
Add Sparklines to Excel tables to show trends in the data
random numbers randbetween
By john lilleystone March 1, 2020
Use the RANDBETWEEN function in Excel to randomly generate numbers between a specified upper and lower threshold.
DATEADD MSQUERY
By john lilleystone March 1, 2020
Don't waste time manually editing queries to move the date period on one month. This blog explains how to use DATEADD to dynamically shift the dates on one month on each refresh
By john lilleystone February 29, 2020
Import text files into Excel and use the Text to Columns wizard to separate the data into columns
By john lilleystone February 26, 2020
Return the last non-zero value in a row in Excel
By john lilleystone February 4, 2020
Extract values or strings from a cell from either the left, middle or right part of the cell
Show More