Column 1: 250 names: Column 2 only the last 4 characters of
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....

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
  •  

 

 
DMCA.com