| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Limits of Substitute and Replace functions
Hi and thanks in advance,
I am using Excel 2003 I have a sheet that has in column A some long strings and I want a quick way, preferably without looping, to replace some characters with another character. The problem I have run into is that when I use Replace in VBA it is only applied to cells with no more than 1024 characters and so I tried using Substitute but that crashes if there is more than 1271 characters in a cell so I don't know how to process these long strings quickly. I tried the following and hit the limits mentioned above: Code:
Range("A:A").Select
Selection.Replace What:=strOld, Replacement:=strNew, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Code:
With Range("A1", Range("A" & Rows.Count).End(xlUp))
.Value = Application.Substitute(.Cells, strOld, strNew)
End With
|
| 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 | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Threaded Mode
