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

Thread: Parse data

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Marion, Illinois
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need a statement that will parse the last eight characters from a text cell

    A1= "4B3AG42H31E110359"
    =
    A2 = "1E110359"

    Thanks



  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-05 10:57, mabsher wrote:
    I need a statement that will parse the last eight characters from a text cell

    A1= "4B3AG42H31E110359"
    =
    A2 = "1E110359"

    Thanks


    =RIGHT(A1,8)

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-05 10:57, mabsher wrote:
    I need a statement that will parse the last eight characters from a text cell

    A1= "4B3AG42H31E110359"
    =
    A2 = "1E110359"

    Thanks

    USE
    =RIGHT(A1,8)

  4. #4
    Guest

    Default

    On 2002-03-05 10:59, Barrie Davidson wrote:
    On 2002-03-05 10:57, mabsher wrote:
    I need a statement that will parse the last eight characters from a text cell

    A1= "4B3AG42H31E110359"
    =
    A2 = "1E110359"

    Thanks


    =RIGHT(A1,8)

    Regards,
    Have also a macro for this formule.
    I want to do the following:
    I put in the numbers in column A from a sheet.
    Than by recording the macro,the last two numbers are the indentification for the column.Example:

    Colum A

    100001
    101002
    110003

    Result after the sorting:

    A B C

    1000
    1010 1100

    So I have a 750 numbers in column A which I have to sort on the last two numbers in the column A,B,C,D,E, etc.
    Is this possible?
    Many thanks.

  5. #5
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have also a macro for this formule.
    I want to do the following:
    I put in the numbers in column A from a sheet.
    Than by recording the macro,the last two numbers are the indentification for the column.Example:

    Colum A

    100001
    101002
    110003

    Result after the sorting:

    A B C

    1000
    1010 1100

    So I have a 750 numbers in column A which I have to sort on the last two numbers in the column A,B,C,D,E, etc.
    Is this possible?
    Many thanks.
    I'm sorry, but I don't understand your requirements. Can you clarify what you want to do here please?

    Thanks,

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

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
  •