CHAR function


Excel » Functions » Text » CHAR function »

How to use the CHAR function

Use CHAR function to convert a¬†number to the corresponding character. This is determined by your computers character set. Windows ANSI […]

Working with classic ciphers in Excel

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

Easily select data using hyperlinks

The image above shows two hyperlinks, the first hyperlink lets you select a data set automatically based on a dynamic […]

Navigate to first empty cell using a hyperlink formula

This article will demonstrate how to create a hyperlink that takes you to the first empty cell below data in […]

How to generate random numbers and text

What's on this page Random numbers with a decimal Random negative numbers with two decimals Random negative numbers with three […]

How to create random numbers, text strings, dates and time values

The RAND() function In Excel returns a number greater than or equal to 0 (zero) and less than 1. Combining […]

Populate cells dynamically in a weekly schedule

In this post I am going to add one more function to the weekly schedule I built in a previous […]

How to extract email addresses from an Excel sheet

  Question: How to extract email addresses from this sheet? (See pic below) Answer: It depends¬†on how the emails are […]