Concatenation operator &

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i add a dash between each string and if there is no string2 not have
the dash appear
 
Assuming that string2 is Null, and not just an empty string (""), you can
take advantage of the fact that + works differently with concatenation than
&:

string1 & ("-" + string2)

If it's not null (or if it's sometimes Null but sometimes not), you'll need
something like

string1 & IIf(Len(string2 & "") > 0, "-" & string2, "")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Dashed line formatting 0
Formatting the SSN 9
Displaying zeros in cells 2
Overcoming win 10's nonsupport of Office 2000 3
Excel function problem 3
9-Digit Zip Code Mask without the dash 3
Dashes in Social Security Number 4
how do I strip spaces and replace with dashes 4

Back
Top