Hi,

I have a spreadsheet that has two columns for vendor addresses. Address 1
col. has the street number and name and the Address 2 col. has the suite
number or Apt number, etc. I want to combine the two addresses into one cell
on one line in the cell with a comma and a space seperating the two
addresses. The problem I'm encountering is when there is not a second address
the comma is still appearing. How do I eliminate the comma when there is no
second address?


Thank You,