Compliance in the Cloud

Excellence

Prerequisites

  • Microsoft® Windows®
  • Microsoft® Excel® 2010 or later
  • Compliance in the Cloud's Excellence add-in

ASCIITEXT

The ASCIITEXT function is used to generate a text value containing all of the characters from the ASCII character table, from the first position to the last position.

ASCIITEXT(first,last)

first
A numeric value indicating the number of the first character from the ASCII table to include.
last
A numeric value indicating the number of the last character from the ASCII table to include.

#VALUE is returned if the first value is greater than last value.

=ASCIITEXT(48,57) will output "0123456789"

=ASCIITEXT(97,122) will output "abcdefghijklmnopqrstuvwxyz"