+ Reply to Thread
Results 1 to 2 of 2

2 random character.

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    18

    Red face 2 random character.

    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

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: 2 random character.

    =char(97 + randbetween(0, 25)) & "-" & a1 & "-" & char(97 + randbetween(0, 25))
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1