Excel Random Numer generating code question?

1 reply [Last post]
Sat, 01/16/2010 - 15:14
Addibeepire
User offline. Last seen 2 years 35 weeks ago. Offline
Joined: 06/05/2009
Posts: 3

Hello,
In Microsoft Excel, I would like a code or a way, that will create a random number after 3 letter - Like ASP1234.

I am using =RAND()*(9999-1000)+1000 for the random number at the moment but NEED ASP before it and ASP=RAND()*(9999-1000)+1000 doesn't work.

the documtn will be .csv for upload to an FTP.
I will be using this code to create hundreds of values so I don't want to keep typing ASP for each.

Anyone know a code? or method?

‹ How to enable slicers on a locked worksheet - Excel 2010 When I press the up arrow key in Excel 2003 my volume control moves down? ›
Top
Tue, 01/26/2010 - 08:09
#1
XlGeek
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 01/26/2010
Posts: 1
Random Number with Prefix

Hi If I understand correctly, you would like to generate random numbers as follows...
ASP6841.21509146252
ASP1637.79201591248
ASP4139.75684682849

If that is so you can do following in excel cell....

="ASP"&RAND()*(9999-1000)+1000

Let me know if I understood your requirement correctly.

Top