+ Reply to Thread
Results 1 to 15 of 15

Randomize number and text

  1. 04-15-2014, 01:06 AM #1
    Domino, S.Kom
    Domino, S.Kom is offline
    Registered User
    Join Date
    04-15-2014
    Location
    Purwokerto, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Exclamation Randomize number and text

    SOLVED..THX..sktneer..n Thank you to all who have helped
    Last edited by Domino, S.Kom; 04-16-2014 at 01:40 AM.
    Reply With QuoteRegister To Reply
  2. 04-15-2014, 01:22 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Randomize number and text

    Hi Domino and welcome to the forum,

    Put the following formula in a cell and drag it to other adjacent cells to see if it is what you want.

    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 04-15-2014, 01:36 AM #3
    Domino, S.Kom
    Domino, S.Kom is offline
    Registered User
    Join Date
    04-15-2014
    Location
    Purwokerto, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Randomize number and text

    Quote Originally Posted by MarvinP View Post
    Hi Domino and welcome to the forum,

    Put the following formula in a cell and drag it to other adjacent cells to see if it is what you want.

    Please Login or Register  to view this content.
    I've tried the formula but the results just appear one character, I want at least 6 characters such as the blackberry pin..thx in advance
    Reply With QuoteRegister To Reply
  4. 04-15-2014, 02:19 AM #4
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Randomize number and text

    Or maybe this?

    =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)

    Cheers
    Reply With QuoteRegister To Reply
  5. 04-15-2014, 02:24 AM #5
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Randomize number and text

    I think the OP wants at least 6 characters, Azumi, and I'm not sure the first two should be necessarily upper-case letters?

    Just take MarvinP's suggestion and concatenate it 6 times.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  6. 04-15-2014, 02:27 AM #6
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Randomize number and text

    You can customized as your need:

    =CHAR(RANDBETWEEN(65,90)) is for randomize text

    =RANDBETWEEN(10,99) is for randomize number

    you can combine them with "&"

    Regards
    Reply With QuoteRegister To Reply
  7. 04-15-2014, 02:29 AM #7
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Randomize number and text

    Quote Originally Posted by XOR LX View Post
    I think the OP wants at least 6 characters, Azumi, and I'm not sure the first two should be necessarily upper-case letters?

    Just take MarvinP's suggestion and concatenate it 6 times.

    Regards
    Yep maybe you right.....
    Reply With QuoteRegister To Reply
  8. 04-15-2014, 02:52 AM #8
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Randomize number and text

    You may try this.......
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  9. 04-15-2014, 03:09 AM #9
    Domino, S.Kom
    Domino, S.Kom is offline
    Registered User
    Join Date
    04-15-2014
    Location
    Purwokerto, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Randomize number and text

    thx to Azumi n sktneer.
    thank you for the advice, I mean not just random numbers and text only, but the order is also random. so the text could be the first is not a number..for the example 1. 35u7Tr
    2. r4T35W. 3. 4D5w89, etc..
    Reply With QuoteRegister To Reply
  10. 04-15-2014, 03:11 AM #10
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Randomize number and text

    @sktneer

    Have I missed something? How are you certain that it should always be of the form:

    [number][number][upper-case letter][number][upper-case letter][number]?

    Regards
    Reply With QuoteRegister To Reply
  11. 04-15-2014, 03:12 AM #11
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Randomize number and text

    Quote Originally Posted by Domino, S.Kom View Post
    thx to Azumi n sktneer.
    thank you for the advice, I mean not just random numbers and text only, but the order is also random. so the text could be the first is not a number..for the example 1. 35u7Tr
    2. r4T35W. 3. 4D5w89, etc..
    See post #5. Simply take Marvin's suggestion and concatenate 6 times.

    Regards
    Reply With QuoteRegister To Reply
  12. 04-15-2014, 03:17 AM #12
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Randomize number and text

    Quote Originally Posted by MarvinP View Post
    Hi Domino and welcome to the forum,

    Put the following formula in a cell and drag it to other adjacent cells to see if it is what you want.

    Please Login or Register  to view this content.
    @Domino

    Formula from Marvin is workin perfect, you just concatenated them with "&" as you need maybe 5 or six time.... like my example how to combine 3 formula...
    Reply With QuoteRegister To Reply
  13. 04-15-2014, 03:17 AM #13
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Randomize number and text

    See if this helps..............
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  14. 04-15-2014, 06:14 AM #14
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: Randomize number and text

    Pl see attached file with UDF Randtext().
    Reply With QuoteRegister To Reply
  15. 04-16-2014, 01:45 AM #15
    Domino, S.Kom
    Domino, S.Kom is offline
    Registered User
    Join Date
    04-15-2014
    Location
    Purwokerto, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Thumbs up Re: Randomize number and text

    thx sktneer..IT'S WORK...n Thank you to all who have helped
    Reply With QuoteRegister To Reply
  16. 04-16-2014, 02:40 AM #16
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Randomize number and text

    Glad to help you. Thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating randomize number sets
    By aaaaa34 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 02-28-2014, 10:48 AM
  2. Excel Randomize Text
    By mrbaselier in forum Excel General
    Replies: 3
    Last Post: 05-27-2011, 10:48 AM
  3. Randomize Order of Text
    By chelseasikoebs in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-01-2009, 12:01 AM
  4. Randomize text paragraphs within Excel?
    By merlinator in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2009, 11:32 AM
  5. [SOLVED] How do I randomize ascending data (number values) in excel?
    By Christa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2005, 05:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1