Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Column 1: 250 names: Column 2 only the last 4 characters of

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi,

    I want to create 4 character login names from a column with 250 adressen. Example:

    column 1: Miss L. chackenbackerslacher
    Column 2: acher

    Column 1: mrs P. diddy
    Column 2: iddy


    The point is, not all names have the same length otherwise I could just pull a simple substring.

    I tried working with the mid function but this only works from position 1. I looking for a "reverser" (start at end) mid function or something.


    To be honest: If I`d put some effort in it, I could figure this one myself of course. But I know that there are users here who can just dream codes like these. It wil save me a lot of time so I owuld be gratefull if someone would help me out.

    Cheers,
    Dinictus.

    [ This Message was edited by: Dinictus on 2002-03-27 02:13 ]

    [ This Message was edited by: Dinictus on 2002-03-27 02:27 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried the RIGHT Function?


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OMG,

    I will go and be ashamed the rest of the day now. Sometimes you make things more difficult then they really are.

    thanks.
    Din.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I dated a Miss L Achenbackerslacher, actually....


    anyhow,

    are you okay if you have 2 Mr Smiths or a number of Miss Whites etc etc etc....

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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