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.


--
Smeeg
------------------------------------------------------------------------
Smeeg's Profile: http://www.excelforum.com/member.php...o&userid=29099
View this thread: http://www.excelforum.com/showthread...hreadid=518314