ampersand operator unexpectedly trims?
 

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

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

ampersand operator unexpectedly trims?
 

Woody

you only have one space before abc and one after abc which is what the
return result shows

"_" & " abc " & "_"

gives a string of

_ abc _


---
Message posted from http://www.ExcelForum.com/

ampersand operator unexpectedly trims?
 

how do you explain this?

? "_"; Space(10); "_"
_ _

or this?

?"_ _"
_ _

"mudraker " wrote in message
...
Woody

you only have one space before abc and one after abc which is what the
return result shows

"_" & " abc " & "_"

gives a string of

_ abc _


---
Message posted from http://www.ExcelForum.com/

ampersand operator unexpectedly trims?
 

mudraker wrote in
:

Woody

you only have one space before abc and one after abc which is what the
return result shows

"_" & " abc " & "_"

gives a string of

_ abc _


---
Message posted from http://www.ExcelForum.com/


no, there are 3 spaces before and after "abc". This should make it more
obvious:

?"_" & space(3) & "abc" & space(3) & "_"
_ abc _

ampersand operator unexpectedly trims?
 

I don't know the correct answer but I beleive it has to do with VB
using _ as the symbol theat the line of code is continued on to th
next line and VBA automatically removing all extra spaces betwee
operators

--
Message posted from http://www.ExcelForum.com

ampersand operator unexpectedly trims?
 

This one's worthy of inclusion in j-walk's 'Excel Oddities':

http://j-walk.com/ss/excel/odd/index.htm

--