How to Generate CELL C1 unique and random in Microsoft Excel?
<p>Here the problem case:<br>
Say The source is <strong>A1: A80</strong> 
( Here <a href="https://goo.(dot).gl/OTa7gM" rel="nofollow">https://goo.(dot).gl/OTa7gM</a> sample file ) &lt;-- please change .(dot). to only one dot (.)</p>

<p>In cell <strong>B1</strong> randoom need VALUE string generated from the range <strong>A1: A80</strong><br>
In cell <strong>B2</strong> randoom need VALUE string generated from the range <strong>A1: A80</strong> but not same to the <strong>B1</strong><br>
In cell <strong>B3</strong> need randoom VALUE string generated from the range <strong>A1: A80</strong> but not same to the <strong>B1</strong> and not same to the <strong>B2</strong><br>
In cell <strong>B4</strong> randoom need VALUE string generated from the range <strong>A1: A80</strong> but not same to the <strong>B1, B2, B3</strong><br>
...<br>
..<br>
.<br>
and so on may be up to 25 rows  </p>

<p>Next in column <strong>C1</strong> i need the combination / CONCATINATE of <strong>B1: B25</strong> (separated by comma) but in this cell <strong>C1</strong> must not more then 500 characters.<br>
If more then it must trim, or better bellows the number of 480 characters.</p>

<p>So the goal I want to generate a maximum of 500 characters (preferably less) in an Excel cell.</p>

<p><em><strong>please by formula, not macro or VBS, Thank You</strong></em></p>