Opposite of Concatenate function?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Opposite of Concatenate function?

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need a function or VBA code to pull the last 6 digits out of a whole column of cells. Anybody know this? It's a list of vehicle VIN numbers and I need to make a separate column of just the last 6 digits of that VIN. Help! Thx.

  2. #2
    Guest

    Default

    Function(s) exists for this sort of thing:

    =Left(A1,2) would give the first two characters of A1
    =Right(A1,2) would give last two
    =mid(A1,2,1) would give one character starting at character 2.

    Hope this helps

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if your numbers are in A1 use =RIGHT(A1,6)

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If VIN numbers are fixed length you can use the Data | Text to Columns... menu command. BTW, the "opposite of concatenation" is called parsing.

    [ This Message was edited by: Mark W. on 2002-02-28 06:45 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks! I'll try those.

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,827
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    > BTW, the "opposite of concatenation" is called parsing.

    Exploding might be more appropriate here than 'parsing' which has a special, technical meaning in linguistics and computer science and involves more often not the syntax of sentences or expressions in a programming (or command) languages.

  7. #7
    Guest

    Default

    On 2002-02-28 07:22, Aladin Akyurek wrote:
    > BTW, the "opposite of concatenation" is called parsing.

    Exploding might be more appropriate here than 'parsing' which has a special, technical meaning in linguistics and computer science and involves more often not the syntax of sentences or expressions in a programming (or command) languages.
    "Parse" is accepted terminology for Excel. In fact as indicated in the Help topic for "Frequently asked questions about upgrading from Microsoft Excel 4.0" there used to be a Data | Parse menu command which was replaced by the Data | Text to columns... menu command. Currently, there's a Help Index entry for "parsing text into columns" that's linked to the Help topic for "Separate copied text data into columns".

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hello friend

    I have found that instead of using the concantenating function,The & (and) work just as good especially for VB.

    Lot of luck

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