Returning a random selection from the content of a cell

[CDandVinyl]

In A1 I have these symbols :

!@#$%^&*()


I'd like in A4 to enter a formula which would randomly select and return one of these symbols.


Grateful for any advice on this.

[GeoffW283]

Please try in A4:

=MID(A1, RANDBETWEEN(1,10), 1)

[Phuocam]

Use this formula for excel 2003:

=MID(A1, 1+INT(RAND()*LEN(A1)), 1)

[CDandVinyl]

Ok Thanks guys. That's solved it.

[GeoffW283]

Thanks for the feedback and rep

I think randbetween() was available in XL 2003 (via the analysis toolpack) right?