How do i put two formulas in one cell? One of them is to randomize a letter and one is to randomize a number.

[Ihavenoclueexcel]

I need to create a cell that has a randomized number and letter right next to each other like “J7, B9, A2, etc” I tried doing this “=CHAR(RANDBETWEEN(65,90))=RANDBETWEEN(0,9)” but this did not work. Ive used &, “”, ;” all as symbols and nothing lets me do this. Also I’m on the free web version so i cant do custom cell formats. Any suggestions?

 

[Ihavenoclueexcel]

I also need those numbers to stay in place, like not change once they are randomized. Then i want to be able to drag it down so it repeats in other cells (without changing)

 

[Michael M]

Replace the = sign in the middle of the formula with an ampersand

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

 

[Peter_SSs]

Try
=CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(0,9)
Then copy the cell and Paste Special (Values)
Then select the cell, hold the Ctrl key down and drag the Fill Handle at the bottom right of the cell downwards

 

[Ihavenoclueexcel]

Try
=CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(0,9)
Then copy the cell and Paste Special (Values)
Then select the cell, hold the Ctrl key down and drag the Fill Handle at the bottom right of the cell downwards

I cannot paste as special values but i copied the same formula. How do i make the numbers stay the same once they are generated? They keep changing. (Also I’m using the web version on an iPad)

 

[mikerickson]

I also need those numbers to stay in place, like not change once they are randomized. Then i want to be able to drag it down so it repeats in other cells (without changing)

That's not going to happen with formulas. RAND and RANDBETWEEN change every time any cell in the workbook is changed.
If you want to drag down a random letter with a given number, you can do that but the letter will change with every change to the workbook.

 

[Peter_SSs]

I cannot paste as special values

Then just re-type them over the top - it is only two characters.