How do I create 6-character upper/lower case code macro/formula?

[dredd351]

I am somewhat new to Excel. I dont have any experience in creating formulas or macros in Excel.
I need to create a way to randomly generate 6-character codes like vW4Rhy, Loe49a, or Ccre90.
each column can use alpha (upper/lower) and numeric characters.

What is the best way and how can I do this?

Any help is appreciated.

[:) Sixthsense :)]

Will create random A-Z Character

=CHAR(RANDBETWEEN(65,90))

Repeating it 6 times will produce 6 random A-Z characters

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

Will create random a-z Character

=CHAR(RANDBETWEEN(97,122))

Repeating it 6 times will produce 6 random a-z characters

=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))

Joining both will produce 6 random characters of A-Z and 6 random characters of a-z

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))

[adyteo]

try this one (pretty long)

Please Login or Register  to view this content.

[Debraj Roy]

With respect to SS.. just a lil bit modification...

Please Login or Register  to view this content.

and a vba one...

Please Login or Register  to view this content.

In cell write formula as "=SixTHRnd()"

both will calculate in calculation.