Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Sat, 12 Jul 2003 at 15:56:15, J.E. McGimpsey (J.E. McGimpsey
) wrote: Replace() isn't recursive - it will replace each pair of spaces with a single space as it "travels" the string left to right. Once it's replaced the two spaces in positions 4&5, it continues with position 6. Any other way lies madness... Imagine Replace("Two Pints", " ", " ") 'one space each if the method started at the character it replaced with, it would get stuck in an infinite loop. Well that would be silly thing to do wouldn't it -- Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
Strange "FormatCells" behaviour | Excel Worksheet Functions |