vzachin
07-20-2007, 07:36 AM
hi,
i have a cell that contains a string of about 1044 characters mixed with spaces. i want to remove these spaces but am running into a problem with an error message "FORMULA IS TOO LONG" when i do it manually.
i then tried the following but it doesn't work either.
Range("B3").Select
Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
as well as
Range("B3").Replace " ", ""
this will work only if there are less than 1044 characters, but i don't know what the threshold is.
is there a way to remove these spaces?
thank
zach
i have a cell that contains a string of about 1044 characters mixed with spaces. i want to remove these spaces but am running into a problem with an error message "FORMULA IS TOO LONG" when i do it manually.
i then tried the following but it doesn't work either.
Range("B3").Select
Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
as well as
Range("B3").Replace " ", ""
this will work only if there are less than 1044 characters, but i don't know what the threshold is.
is there a way to remove these spaces?
thank
zach