Results 1 to 3 of 3
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 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 29 Times in 29 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
  •