# Excel random uppercase and lowercase letter, fixed-length letters

Source: Internet
Author: User
Tags lowercase rand

In Excel can produce random numbers, but also produce random letters, even random numbers and letters of the combination, want to produce a length of several.

In addition, if it is a random letter, it can also produce a single case of random letters or mixed random letters.

① Random lowercase letters: a

=char (INT (RAND () *25+97))

② Random Capital Letter: A

=char (INT (RAND () *25+65))

③ Random Number: A

=char (INT (RAND () *9+48))

④ random digit uppercase and lowercase letters: a

if (int (rand () *2) =0,char (int (rand () *9+48)), if (Int (rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)))

⑤ random size letters and numbers, with a number of digits of 6 digits

=concatenate (if Int (rand () *2) =0,char (int (rand () *9+48)), if (int () () *2) =0,char (int (rand () *25+65)),

CHAR (int (rand () *25+97))), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () () *2) =0,char (int ()

*25+65)), CHAR (int (rand () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (Int (rand () *2) =0,char (

Int (rand () *25+65)), CHAR (int () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () *2)

=0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () (

Rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)), IF (int (rand () *2) =0,char (int () () *9+48)

), IF (int (rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97))))

Related Keywords:
Related Article

## E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

## Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

## Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD