473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to write a alphanumeric code

I want an example of how to write an alphanumeric code
Mar 7 '14 #1
7 5716
This is a very good site it help with all kinds of IT stuff
Mar 7 '14 #2
=CHAR(CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(48,57),R ANDBETWEEN(65,90)))

to get a random alphanumeric character... or, 5 of those concatenated to get a 5 character one: =CHAR(CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(48,57),R ANDBETWEEN(65,90)))&CHAR(CHOOSE(RANDBETWEEN(1,2),R ANDBETWEEN(48,57),RANDBETWEEN(65,90)))&CHAR(CHOOSE (RANDBETWEEN(1,2),RANDBETWEEN(48,57),RANDBETWEEN(6 5,90)))&CHAR(CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(4 8,57),RANDBETWEEN(65,90)))&CHAR(CHOOSE(RANDBETWEEN (1,2),RANDBETWEEN(48,57),RANDBETWEEN(65,90)))

Just press F9 to get a new value, or use a looping macro for your "... at least one character in the result would be a letter" restriction.

note: RANDBETWEEN requires the analysis toolpak.
Mar 7 '14 #3
Nepomuk
3,112 Expert 2GB
Generally speaking, alphanumeric code is code containing latin letters (A-Z and a-z) as well as arabic digits (0 through 9). Or do you mean alphanumeric shellcode?
Mar 7 '14 #4
Hi Nepomuk,
I like the way u reply,i learned frm u that first we need knw wht exactly they looking for,definition its nice.
Thanks for ur answer.
Mar 7 '14 #5
Nepomuk
3,112 Expert 2GB
Hi 2147483648!

Yes, it's always good to know what exactly the question is. ;-) Your solution seems to create random alphanumeric code, though I'm not sure which language that is supposed to be. Maybe VBA?

But back to the question: Iamtrey3, if the replies so far answer the question, great. If not, please specify what exactly you want to know.
Mar 7 '14 #6
Thank you very much for making me to realize quickly Nepomuk.
I will appreciate and accept ur response without hesitation.
Mar 8 '14 #7
Your question is not clear, [A-Z|a-z|0-9]+ is considered as alphanumeric word.
Jun 9 '14 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: silviu | last post by:
Hi All, I have to write C++ code (server code) that will compile/run on both Windwos and Linux OS's. Could someone give me some pointers to info on this matter. Thanks in advance for your...
16
by: White Wolf | last post by:
Hello, I am looking for Hungarians, who read this newsgroup and are interested in the Standard C++ Programming Language. I am trying to help to organize a group of Hungarians, who are expert...
5
by: Jay | last post by:
Hello everyone, I just got done taking a small course in ASP.NET and I'm completely sold. This is amazing compared to original ASP. My question is about the preferred method of coding the asp...
1
by: Pratchaya | last post by:
Hi, All Can i write php code to connect 2 MySQL DB. like this case. ? My Environment : Server < ---- > PC Client Server =
5
by: pradeep | last post by:
how to write antiviirus code using c++
3
by: kumarabhijit | last post by:
Hi, Can anyone help me about how to write Marshalling code for Function pointer in cpp? Thanks Abhijit
8
seshu
by: seshu | last post by:
hi every body This is seshu, here iam able write a code in vb6 on controle arrays ofcourse while designing it self i made my controls as arrays but here in .net i dint find that...
20
by: Victor Smootbank | last post by:
I did program in BASIC for more than 20 years and for me it's still the ultimate programming language. Unfortunately, I was forced to upgrade to C++ and now I'm confused. While programming in...
1
by: suratna | last post by:
i have an xslt file. i have no problem writing html code inside it but when i write a mysql select query inside it, it gives error. Is there any way to write php code inside xslt file? ratna
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.