Dear Mr, Guru, Rabbi, teacher, of excel :
i have a cell say from a1 to a4.
ab
ac
ad
ae
id like to combine it to 2 random character so from b1 to b4 will be :
o-ab-g
a-ac-h
g-ad-j
e-ae-7
where the first and the last character will be randomize
Regards,
Hong
Bookmarks