Results 1 to 7 of 7

Opposite of 'CONCATENATE'

This is a discussion on Opposite of 'CONCATENATE' within the Excel Questions forums, part of the Question Forums category; Hi, If I have something like this in say cell Z1 0001234smith00x23435600abc Is there any way that I can put ...

  1. #1
    Board Regular
    Join Date
    Jul 2002
    Posts
    53

    Default Opposite of 'CONCATENATE'

    Hi,
    If I have something like this in say cell Z1
    0001234smith00x23435600abc
    Is there any way that I can put the first 5 characters in cell A1 the next 7 in B1 the next 4 in C1 .....etc
    What I am trying to do is the opposite of the CONCATENATE function.

    Ken

  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    509

    Default Re: Opposite of 'CONCATENATE'

    This would extract the first five characters:

    =left(z1,5)

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    Dublin, CA.
    Posts
    109

    Default Re: Opposite of 'CONCATENATE'

    =left(z1,5)
    =mid(z1,6,7)
    =right(z1,15)

  4. #4
    Board Regular
    Join Date
    Jul 2002
    Posts
    53

    Default

    Berg891832,
    That works well for the beginning characters, but what about those in the middle, or for instance only the 4th and 5th characters??
    Has anybody got any ideas?

    Ken

  5. #5
    Board Regular
    Join Date
    Jul 2002
    Posts
    53

    Default

    Tonyson,
    Thanx mate !
    Exactly what I was looking for.

    Ken

  6. #6
    Board Regular
    Join Date
    May 2002
    Location
    Dublin, CA.
    Posts
    109

    Default Re: Opposite of 'CONCATENATE'

    you're welcome!

  7. #7
    Board Regular indiantrix's Avatar
    Join Date
    Oct 2002
    Location
    Philadelphia 'Burbs
    Posts
    943

    Default Re: Opposite of 'CONCATENATE'

    OR...if you had a whole column of similar data, you could use the Data>Text to Columns feature, choose fixed width columns, and then follow the instructions to separate the data into desired column widths. Cheers! /s/ Larry

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