ampersand operator unexpectedly trims?
It looks like it has something to do with the underscores. For instance:
?"_ _"
_ _
?"' '"
' '
?"_ '"
_ '
?"" Space(10) "<"
<
? "_" Space(10) "_"
_ _
? "_"; Space(10); "_"
_ _
? "_" Tab(10) "_"
_ _
? "" Tab(10) "<"
<
using Win 2K, Excel 2002
"Woody" wrote in message
.121...
In the immediate window, I input:
? "_" & " abc " & "_"
and it returns:
_ abc _
Why did it knock off all but one of the spaces off the right side of the
middle string?
Thanks,
Woody
|