Results 1 to 12 of 12

Thread: NEED SOMEONE W/ EXCEL SKILLS WANTING TO MAKE SOME MONEY...

Hybrid View

  1. #1
    Don't ya like clowns? Paul's Avatar
    Join Date
    Feb 2001
    Age
    45
    Posts
    29,970
    Rep Power
    1060

    Default NEED SOMEONE W/ EXCEL SKILLS WANTING TO MAKE SOME MONEY...

    I NEED SOMEONE TO EITHER CREATE A QUICK MACRO OR JUST FIGURE OUT A WAY TO DO THIS W/O MY INTERVENTION. I NEED THIS DONE ASAP AND I WILL PAYPAL YOU MONEY UPON COMPLETION.

    BASICALLY...

    I HAVE A EXCEL FILE W/ 3 COLUMNS:

    PART#(COLUMN1,(20CHAR)), ID#(COLUMN2,(20CHAR)), DESC(COLUMN3)...

    Currently column3 has random amount of characters depending on description, i need this column broken down into 45 char max with the remaining characters made into a separate record using the same column1/column2... it would probably be helpful to create a unique id for every record or number the records.

    example:
    12345, 67890, blah blah blah blah blah blah blah blah
    i need it to be:
    12345, 67890, blah blah blah blah,12345-001
    12345, 67890, blah blah blah blah,12345-002
    if you can do this PM me ASAP
    Paul "your bullshit makes the flowers grow"

  2. #2
    Duck of Death ShooterMcGavin's Avatar
    Join Date
    Jun 2003
    Location
    right behind you...
    Age
    43
    Posts
    24,836
    Rep Power
    54

    Default

    um i understand the 1st part of your request just fine...up until:

    "with the remaining characters made into a separate record using the same column1/column2"

  3. #3
    Don't ya like clowns? Paul's Avatar
    Join Date
    Feb 2001
    Age
    45
    Posts
    29,970
    Rep Power
    1060

    Default

    Quote Originally Posted by shagwAg3n
    um i understand the 1st part of your request just fine...up until:

    "with the remaining characters made into a separate record using the same column1/column2"
    i need the data broken into separate records b/c the DB system this is going into has a 50 char limit - meaning if the 3rd column has 100 characters it would need to be put into a separate record and that record still needs the appropriate column1/2
    Paul "your bullshit makes the flowers grow"

  4. #4
    Ghost AirMax95's Avatar
    Join Date
    Jun 2005
    Location
    On a Plane
    Posts
    4,431
    Rep Power
    27

    Default

    Can you PM sample data?

  5. #5
    Duck of Death ShooterMcGavin's Avatar
    Join Date
    Jun 2003
    Location
    right behind you...
    Age
    43
    Posts
    24,836
    Rep Power
    54

    Default

    Quote Originally Posted by AirMax95
    Can you PM sample data?

  6. #6
    Yes joecoolfreak's Avatar
    Join Date
    Feb 2006
    Location
    Austin, TX
    Age
    45
    Posts
    616
    Rep Power
    22

    Default

    Solution sent

  7. #7
    A.D.I.D.A.S. §treet_§peed's Avatar
    Join Date
    Dec 2005
    Location
    Gainesville
    Age
    38
    Posts
    24,950
    Rep Power
    49

    Default

    bastard i was about to make it
    You know better; next time will be a ban.

  8. #8
    Don't ya like clowns? Paul's Avatar
    Join Date
    Feb 2001
    Age
    45
    Posts
    29,970
    Rep Power
    1060

    Default

    i sent the file to couple people first to do it gets $$$
    Paul "your bullshit makes the flowers grow"

  9. #9
    Duck of Death ShooterMcGavin's Avatar
    Join Date
    Jun 2003
    Location
    right behind you...
    Age
    43
    Posts
    24,836
    Rep Power
    54

    Default

    i didn't get it

  10. #10
    Don't ya like clowns? Paul's Avatar
    Join Date
    Feb 2001
    Age
    45
    Posts
    29,970
    Rep Power
    1060

    Default

    obviously you didn't read directions PM me... i have someone working on it now anyway
    Paul "your bullshit makes the flowers grow"

  11. #11
    Duck of Death ShooterMcGavin's Avatar
    Join Date
    Jun 2003
    Location
    right behind you...
    Age
    43
    Posts
    24,836
    Rep Power
    54

    Default

    hater hope they send you back an excel file w/a virus

  12. #12
    A.D.I.D.A.S. §treet_§peed's Avatar
    Join Date
    Dec 2005
    Location
    Gainesville
    Age
    38
    Posts
    24,950
    Rep Power
    49

    Default

    lol
    You know better; next time will be a ban.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
ImportAtlanta is a community of gearheads and car enthusiasts. It does not matter what kind of car or bike you drive, IA is an open community for any gearhead. Whether you're looking for advice on a performance build or posting your wheels for sale, you're welcome here!
Announcement
Welcome back to ImportAtlanta. We are currently undergoing many changes, so please report any issues you encounter with the site using the 'Contact Us' button below. Thank you!