Results 1 to 11 of 11
  1. #1
    ABW Founder Haiko de Poel, Jr.'s Avatar
    Join Date
    January 18th, 2005
    Location
    New York
    Posts
    21,609
    How can I get around the ######'s due to the 255 character limit in Excel?
    Continued Success,

    Haiko
    The secret of success is constancy of purpose ~ Disraeli

  2. #2
    Affiliate Manager Allen Nance's Avatar
    Join Date
    January 18th, 2005
    Location
    Colorado River, Bullhead City AZ
    Posts
    1,604
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Haiko:
    How can I get around the ######'s due to the 255 character limit in Excel? <HR></BLOCKQUOTE>

    I always replace it with %%%%%%'s



    .... seriously folks,

    I have that same problem too, and if Haiko can't figure it out, no one can!

    And that's just a little Poop from me!

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    2,419
    Stop using Excel

  4. #4
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Did you try changing the file format? This works for me unless I've got formulas that I can only use in a .xls file.
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  5. #5
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    742
    I think Excel 97 & 2000 do not have the 255 limit, but not sure.

  6. #6
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    Every version of Excel I have ever used, and that should cover them all over various jobs, has always had the 255 limit.
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  7. #7
    Full Member
    Join Date
    January 18th, 2005
    Posts
    291
    same here, and that's where I get the "formula too long" when editing and descriptions cut off.
    lazy person's solution, delete description (peeps read same thing when they click in anyway) and just put *click picture for all the details*
    Actually, I've noticed slightly more sales since I started doing that.

  8. #8
    Affiliate Manager
    Join Date
    January 18th, 2005
    Location
    Los Angeles, California
    Posts
    1,913
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Haiko:
    How can I get around the ######'s due to the 255 character limit in Excel? <HR></BLOCKQUOTE>

    This helps motivate me to make a table viewer/editor part of the WebMerge product as soon as possible. With the text library I'm using we have no such limitation on field data size. In fact, the only limitation is that we can only display records shorter than 65,535 characters, but very few feeds contains records longer than that so it should be quite suitable.

    Please take a moment to descrivbe what you do with your fedd in Excel, and I'll see what I can do to let you do that in WebMerge directly.
    Richard Gaskin
    Developer of WebMerge: Publish any data feed on any site
    http://www.fourthworld.com

  9. #9
    Newbie
    Join Date
    January 7th, 2006
    Posts
    1
    Tableviewer
    Hi Richard,

    Excellent idea to include a table viewer in the next release...
    I would be utterly delighted and much obliged if WebMerge also had a tool to (automatically?) clean up datafeeds.

    Connie

  10. #10
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    I didn't see this thread before.

    I always pull that field out and modify it in my text editor, then put it back in with the new edits in place. Yes, it's one of those things called a "work-around" and it's not pretty.

    As for Richard adding that functionality into WM - cool. However, I am not sure it will solve the real problem for many of us, that is intense, macro-filled editing of certain fields in the file.

    Nothing like not answering the question - to make everyone happy (as I always say ).

    Fred

  11. #11
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Los Angeles
    Posts
    4,053
    How about exporting the spreadsheet to Access?

  12. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Quick question
    By AdrianWinston in forum Commission Junction - CJ
    Replies: 3
    Last Post: August 16th, 2010, 01:43 PM
  2. One really quick question
    By andyparks16 in forum Midnight Cafe'
    Replies: 4
    Last Post: January 12th, 2010, 11:28 PM
  3. quick question
    By pyxlb0mb in forum Newbie Affiliate FAQs & Helpful Articles
    Replies: 4
    Last Post: February 28th, 2007, 11:52 AM
  4. Quick Question...$$$$$$$$$
    By melty in forum Midnight Cafe'
    Replies: 34
    Last Post: September 5th, 2006, 01:20 PM

Posting Permissions

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