Without using some vba code i dont think your first question can be done.
Answer to your secon question, can be done like this
=CONCATENATE(A1,"-",B1,"-",C1)
or
=A1&"-"&B1&"-"&C1
"Donna" wrote:

I would greatly appreciate your time in looking at this.
I have 2 questions.
The first is:
I have 2 columns A and B. Many of the cells are blank in column B. When
column B has information in it, I want it to replace the information in Col A
with the information from Col B-if col B is blank, then keep the
information from Col A.
My second question is how do I insert a -(hyphen) between information when
I am using Concatenate to combine 3 columns (columns A, B & C).
Thanks