ExcelBanter - random combination of letters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - random combination of letters (https://www.excelbanter.com/excel-worksheet-functions/45717-random-combination-letters.html)

random combination of letters

hi all,

does excel has a function to combine randomly a set of letters? for example:
a1:a10 contains different letters, i want to combine those letters in b1:b10
randomly. please help.

yob

Cliff

look at =concatenate(Text1,text2, text3)
You can replace the Text fields with co-ordinates i.e.
=concatenate(a1,a2,a4,a3) etc.
--
Cliff Andrews

"rp" wrote:

hi all,

does excel has a function to combine randomly a set of letters? for example:
a1:a10 contains different letters, i want to combine those letters in b1:b10
randomly. please help.

yob

All times are GMT +1. The time now is 02:42 AM.