Hi,

On way,

=INDEX($A$1:$A$10,INT(RAND()*10)+1,1) & " " &
INDEX($A$1:$A$10,INT(RAND()*10)+1,1) & " " &
INDEX($A$1:$A$10,INT(RAND()*10)+1,1) & " Ltd"

Cheers
Andy

Smeeg wrote:
Hi there,

I'm trying to come up with a random name generator - what I've created
so far is rather cumbersome and there must be a more efficient way.

If column A1:A10 has 10 random words in it, what formula can I use in
B1 which results in something like 'randomword' 'randomword'
'randomword' Ltd

e.g A1:A10

elephant
dog
snake
cat
rabbit
worm
butterfly
chicken
tiger
ape

with a random formula in B1, I would like a result which looks like

elephant cat worm Ltd or
chicken tiger chicken Ltd or
rabbit ape dog Ltd etc....

Thanks in advance.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info