Ever been confused by the \* formatting options in Word field codes? You’re not alone, believe me. Here’s a complete guide with the \* codes and examples of how they appear. In this article we’ll look at the named formatting codes which start with \* like \* Arabic and \* Ordinal and even \* Hex […]
StockHistory() is an Excel function that can add historical stock price info, as well as currency exchange rates at monthly, weekly or daily intervals. Date and Closing Price plus optionally Open, High, Low and Volume. All ready to make a chart for stock price analysis. Excel 365 has Stock and Currency data types but they […]
Type the White or outline Chess King ♔ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess King ♔ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. There’s also a Black Chess King ♚ symbol […]
Word and Office have several down “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown with the codes and shortcuts to type them in Excel, PowerPoint and Outlook too. There are various pointing hand options in Unicode: Index – a pointing index finger with palm facing. Backhand Index – pointing […]
If you’ve ever needed to split dates in Excel into separate day, month, and year, there are several options to choose from. Excel has different functions, Text to Columns or Flash Fill which can do the job. Here’s a quick guide on several methods: Using the DAY, MONTH and YEAR functions Using Text to Columns […]
