Results 1 to 3 of 3
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,396
    Thanks
    164
    Thanked 634 Times in 602 Posts

    Excel 911 Replace mystery (Excel2000/ExcelXP)

    Excel will allow cells to contain formulas up to 1024 chars in length.
    Excel will allow data cells to contain up to 32,000 chars (32k?)
    However,
    ..if you enter up to 911 chars in a cell, the Replace function will work in VBA and you can also directly use the Ctrl-H find-and-replace on the cell.
    ..but if you enter more than 911 chars, e.g 912 (!) then neither work! You get a 'formula too long' error message!
    Anyone know why this is???????

    I'm puzzled. There doesn't seem to be anything 'magic' about 911 (although I undestand this may be what you dial for help in some countries)

    zeddy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 30 Times in 30 Posts

    Re: Excel 911 Replace mystery (Excel2000/ExcelXP)

    Hi zeddy,

    Long time no see!

    This problem is mentioned several times in the Excel newsgroups. It appears to be a "hard" limit built into Excel, although it's not mentioned in the specifications, as far as I know. You could use VBA code to do the replace, see this newsgroup thread for an example (in the reply by Dave Peterson)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel 911 Replace mystery (Excel2000/ExcelXP)

    What is the 911 char string you used. I do not get the formula too long (in XL97) until I hit the 1024 char mark...

    Steve

Posting Permissions

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