formula for random number?

[CRAIG20]

Hi

I have a column (B). I just want to put a random number between 1 and 9 in each of the cells in column B

Can anyone help?

Thanks

 

[CWatts]

=randbetween(1,9)

 

[kpark91]

=rand() * 8 + 1

 

[CRAIG20]

That worked fine.

One other thing In cell A I have a long number. How can I add the random digit in Column B to the end of the long number in column A. I can use Column C for the new number.

EG. Column A says '123456'. Column B says '9'. I want column C then to say 1234569

Thanks

Craig

 

[kpark91]

Something like
=A1 & B1

perhaps?

or
=A1 * 10 + B1

 

[CWatts]

To make it text
=A1&B1

If you want to convert it to number format.
=(A1&B1)+0

 

[kpark91]

To make it text
=A1&B1

If you want to convert it to number format.
=A1&B1+0

I keep forgetting there's a +0 trick

 

[CRAIG20]

perfect.

Thanks everyone.

 

[T. Valko]

I keep forgetting there's a +0 trick

There's also the double unary minus trick.

=--(A1 & B1)