Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Comma Delimited Merging..

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    I have a couple text files that are comma delimited that I have imported into excel.

    My problem is that a handful of the rows had "extra" commas.. resulting in extra columns.

    example:

    San Jose, CA, shirts, orange, green, blue,

    In that case, I'd want to merge "orange, green, blue" into one cell.

    Is there a function to perhaps highlight the columns side by side and merge them all into ONE cell "orange green blue"

    Thank you in advance for your help.


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    England
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Once the data has been imported, you can use the concatenate formula,

    e.g.,

    =CONCATENATE(A1,",",B1,",",C1)

    where A1 to C1 contain your colours

    HTH

    Matt

    [ This Message was edited by: Matt on 2002-03-10 15:06 ]

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

    Default

    Hi ==

    Worth a look at :CONCATENATE should do as you ask..

    =CONCATENATE(Rng1, " ",Rng2, " ",Rng3)

    Use the wizard if needs be can be any rng (range but single cell at a time thou) will just string them together for you.
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried the concatenate

    "e.g.,

    =CONCATENATE(A1,",",B1,",",C1) "

    BUT.. I dont wish to have the seperate cells in the document anymore.

    That does work to merge the cells, but then I wind up with

    color color color , color, color, color
    I only want the "color color color" in there.. if I remove the sperate cells, then of course excel doesnt have that data to reference to.

    Is there no way to "merge" them without having them still there to reference ?

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

    Default

    You can do the =CONCATENATE(A1,",",B1,",",C1)
    and then copy the values from the concatenate to another column using 'paste special' with the values option set.

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
  •