Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace vs Application.Substitute
When replacing text in cells with lots of text, using Replace() will
return a "Formula too Long" error. If I use Application.Substitute, it replaces text just fine. Anyone know why? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace vs Application.Substitute
The replace function must use a fixed length string rather than a variable
length string whereas the application.substitute uses a variable length string. It is the same when you try and copy a worksheet that has text that is more than 255 characters long it truncates it. -- Hope this helps Martin Fishlock "Ski" wrote: When replacing text in cells with lots of text, using Replace() will return a "Formula too Long" error. If I use Application.Substitute, it replaces text just fine. Anyone know why? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace and Substitute Functions | Excel Programming | |||
wildcards with substitute of replace | Excel Programming | |||
Replace/substitute | Excel Programming | |||
Substitute/Replace | Charts and Charting in Excel | |||
Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) |