randomly selecting a cell from a range

I need a cell to display the (text) content of 1 of 25 cells.

example: I have text content in all cells ranging A1:A25

I want cell B1 to display the content of 1 of these at random.

is there a function for this or do I need to use a macro?

all help welcome,

thankyou!

You can use a helper cell to create your random address. In C1:

Please Login or Register  to view this content.

Then in B1:

Please Login or Register  to view this content.

Pressing F9 to recalc will cycle through A1:A25 randomly

For what it's worth, you could do it without the helper cell in C1, by simply using this in B1:

=INDIRECT("A"&RANDBETWEEN(1,25))