+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Need help seperating text from a long string

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need help seperating text from a long string

    Hi guys, Am having a littleb bit of trouble thinking of a way to resolve a probem I have. I have 4 headings that need to be inserted from a long string, that includes alot of unwanted charators.

    My 4 headings are

    Manufacturer / Range / Series / Model

    Ok I will provide a few lines of strings I have to help you understand.

    First Line
    ["Acer"]["Aspire"]["2900 Series"] = new Array("2900","2920","2920-302G25Mi","2920-3A2G12M","2920-3A2G25Mi","2920-5A2G25Mi","2920-602G25Mn","2920-603G25Mi","2920z","2920Z-3A2G12Mi","2930","2930-733G25Mn","2930-734G32Mn","2930-844G32Mn","2930Z","2950");

    Second Line
    ["Acer"]["Aspire"]["5500 Series"] = new Array("5332","5500","5500-ALL MODELS","5500Z","5502-ALL MODELS","5502ZWXCi","5502ZWXMi","5510","5510-ALL MODELS","5515","5515-2077","5515-5187","5515-5705","5515-5831","5515-5879","5515-ALL MODELS","5516","5516-5063","5516-5474","5517","5517-5700","5517-5997","5520","5520-1cw50","5520-5033","5520-5142","5520-5147","5520-5156","5520-5374","5520-5377","5520-5537","5520-5579","5520-5741","5520-5833","5520-5865","5520-5908","5520-5912","5520-5928","5520-6A2G12Mi","5520-7A2G16Mi","5520-ALL MODELS","5520G","5530","5530-5824","5530-703G25MN","5530G","5530G-704G25Bn","5532","5534","5534-1096","5534-1121","5534-1146","5534-1398","5534-5950","5534-L34F","5534T","5535","5535-5018","5535-5050","5535-5452","5535-6608","5535-6826","5535-704G32Mn","5535-ALL MODELS","5536","5536-5105","5536-5165","5536-5218","5536-5224","5536-5663","5536-5872","5536-5883","5536-623G50MN","5536-643G25Mn","5536-643G50MN","5536-644G32Mn","5536-744G32Mn","5536G-744G32MN","5538","5538-1096","5538-1350","5538-1395","5538-313G25MN","5538-514G32Mn","5540","5542","5542-16","5542-1615","5542-303G25Mi","5542-304G32Mi","5542-504G32Mi","5542G-303G25Mi","5542G-304G32Mi","5542G-504G32Mi","5542G-604G50Bi","5550","5551","5551-2013","5551-2036","5551-2380","5551-2805","5551-4200","5551-4937","5551-ALL MODELS","5551-P323G25Mi","5551G-4280","5551G-4591","5552","5552-3036","5552-3104","5552-3640","5552-6838","5553","5553-2847","5553G","5553G-N834G50Mnks","5553G-N934G32Mn","5553G-N934G64Mn","5553G-N936G50Mi","5560","5562","5570","5570-2067","5570-2792","5570-2977","5570-2997","5570-4174","5570-4285","5570-4421","5570-4438","5570-4581","5570-4765","5570Z","55710G-4A2G16Mi","5580","5580-6177","5580-6432","5580-6707","5580-6856","5580-6974","5580WXMi","5582","5583NWXMi","5583WXMi","5584NWXMi","5590","AA5510","AA5516","AA5516-5063","AA5516-5474");

    Third Line
    ["Acer"]["Extensa"]["4620Z Series"] = new Array("4620Z");

    Now lets conentrate on the third line, What am trying to do is get fill in the headings so it wil produce.

    Acer / Exensa / 4620Z Series / 4620z

    if anybody can help me on this id really appreciate it, thanks

    Craig

  2. #2
    Valued Forum Contributor gjlindn's Avatar
    Join Date
    08-01-2011
    Location
    Dodgeville, WI
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    369

    Re: Need help seperating text from a long string

    Could you post an example workbook please? Thanks!
    -Greg If this is helpful, pls click Star icon in lower left corner

  3. #3
    Registered User
    Join Date
    10-02-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help seperating text from a long string

    Thanks I will try to post it up soon,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1