How can I concatenate strings in VBA

Question

This question comes from a comment under Range Formula  in VBA throws a strange error   I wrote that program by trial-and-error so I naturally tried   to concatenate strings   But is  amp  more correct than   for concatenating strings

User · Accepted Answer

amp  is always evaluated in a string context  while   may not concatenate if one of the operands is no string    1     2    gt   12   1    2     gt  3 1    2      gt  3  a    2     gt  type mismatch   This is simply a subtle source of potential bugs and therefore should be avoided   amp  always means  string concatenation   even if its arguments are non-strings    1   amp   2    gt   12   1   amp   2    gt   12   1   amp   2    gt   12   1   amp   2    gt   12   a   amp   2    gt   a2

User · Answer

There is the concatenate function   For example  CONCATENATE E2  -  F2   But the  amp  operator always concatenates strings     often will work  but if there is a number in one of the cells  it won t work as expected

User · Answer

The main  very interesting  difference for me is that   string   amp  Null -   string  while  string    Null -  Null  But that s probably more useful in database apps like Access

[excel] How can I concatenate strings in VBA?

Examples related to excel

Examples related to vba