1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Split text macro

Discussion in 'Business Applications' started by eolverag, Sep 12, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. eolverag

    eolverag Thread Starter

    Joined:
    Sep 12, 2011
    Messages:
    1
    Hi everyone, i have a situation here and hope you could help me solve it.

    I have a spreedshet with consumer information and i want to analyze the data, the spreedsheet i receive has a column named product description and has different information in it that i want it to be splited into different columns. i already try to use the Text to Column wizard but it doesnt help me at all. heres an example of this column.

    Product Description80651906-HS COND RELAX 200MLX12IT80629451-He&S Sh Mentol Refrescante 400mlx12it80651967-HS FALL PREVENTION 700MLX10IT80629515-He&S Sh Limpieza Renovadora 700mlx10it80629521-He&S Sh Esencias Marinas 700mlx10it80649355-HEADSH COND HUMECTA 200MLX12IT BRASIL80639137-PANTENE AC HIDRATACION 200MLX12IT

    The result im looking for should be like this:

    ID Brand Technology Version Size Additional
    80651906 HS COND Relax 200MLX12IT
    80629451 He&S Sh Mentol Refrescante 400mlx12it
    80651967 HS N/A FALL PREVENTION 700MLX10IT
    80629515 He&S Sh Limpieza Renovadora 700mlx10it
    80649355 HEADSH COND HUMECTA 200MLX12IT BRASIL80639137 PANTENE AC HIDRATACION 200MLX12IT

    Could anyone help me to code this on a macro ???
    THX A LOT !!!!
     

    Attached Files:

  2. Keebellah

    Keebellah Hans Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    5,960
    Have you tried the Text to columns?
    Its a standaard menu option in Excel. In Excel 2007 and 2010 you can find it in the ribbon under the Data menu option
    You can even record a macro for future use
     
  3. scotty718

    scotty718

    Joined:
    Nov 19, 2010
    Messages:
    185
    He can't do TTC.The data has to many spaces that may or may not define the columns he needs.

    I've done some manual work with one small vba code, since there would be no code that could just nail it - or at least no code that can be developed very quickly!

    I parsed out ID, Size & Additional. But I didn't know how to separate Brand, Technology & Version. I left that in a column called Data to Finish. That should be pretty easy for you to extract given the small data set.
     

    Attached Files:

  4. Keebellah

    Keebellah Hans Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    5,960
    Okay. I'll check it, first I have to see the match Nadal-Djokovic!!! (I'm for Nadal):)
     
  5. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    This shouldn't be a problem but I would need to see the original data in the actual workbook. Can you post the before and after data in your attached workbook?

    Rollin
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1017271