string concatenation

[Mike NG]

What's the difference between + and & for doing the job?

I thought from using an older version of excel, that + gave you a free
space, which was why I use &, but this no longer seems the case in
xl2000

 

[Rob Bovey]

What's the difference between + and & for doing the job?

I thought from using an older version of excel, that + gave you a free
space, which was why I use &, but this no longer seems the case in
xl2000

Hi Mike,

As far as I know, the ability to use + for string concatenation is
simply there for backward compatibility with early versions of BASIC.
There's no difference in their behavior that I'm aware of.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Dave Peterson]

I make enough mistakes. I don't think I want excel to guess what I really
wanted:

Option Explicit
Sub testme()

Dim myVal As Variant

myVal = 2 + 2: MsgBox myVal
myVal = 2 + "2": MsgBox myVal

myVal = 2 & 2: MsgBox myVal
myVal = 2 & "2": MsgBox myVal

End Sub