Display random text

[bbvierra]

Is there an easy way to display random text in excel? I know it's pretty easy for numbers, but I'm having trouble with text.

In Column B, I have random text in cells B1 through B1000. I would like A1= one of the B column cells at random. A2 = another random B cell, etc. Some of these A cells will have the same value as others, which is not a problem.

Any help is greatly appreciated.

 

[Jonmo1]

Try

=INDEX(B1:B1000,RANDBETWEEN(1,1000))

Randbetween requires the Analysis Toolpack from Tools - Addins.

Hope that helps.

 

[VoG]

Perhaps like this

=INDIRECT("B"&INT(RAND()*1000))

 

[Sektor]

UDF

Function RandomText() As String
    RandomText = Cells("B" & WorksheetFunction.RandBetween(1, 1000))
End Function