Posted to microsoft.public.excel.programming

Woody[_3_] Woody[_3_] is offline

external usenet poster

Posts: 14

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell Format changes unexpectedly	HappyDaddy	Excel Discussion (Misc queries)	1	October 7th 09 04:28 PM
Excel Closes Unexpectedly	Lisa E.	Excel Discussion (Misc queries)	3	December 12th 07 04:33 PM
Excel quits unexpectedly	Simon Brown	Excel Worksheet Functions	1	May 4th 07 11:36 PM
data changes unexpectedly	Helen N.	New Users to Excel	8	December 16th 04 03:49 PM
What does an ampersand mean in VBA?	J S	Excel Programming	2	November 20th 03 07:58 PM

All times are GMT +1. The time now is 02:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us