Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string concatenation
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 -- Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
string concatenation
"Mike NG" wrote in message
... 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 * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
string concatenation
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 Mike NG wrote: 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 -- Mike -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help With String Concatenation | Excel Worksheet Functions | |||
Need Help With String Concatenation | Excel Worksheet Functions | |||
Bold in string concatenation | Excel Discussion (Misc queries) | |||
concatenation | Excel Discussion (Misc queries) | |||
How do I put each member of string concatenation in its own line? | Excel Worksheet Functions |