D
Donna Cornett
I need help with merging four columns together.
I have a column with First Name, then one with Middle
Name, then one with last name and then one with Suffix and
I want to put all them into one column. How do I do this.
I read the help and it says this:
=CONCATENATE(A2," ",B2) But it only shows two columns and
when I tried to add all four it gave me an error.
Can anyone help me? I need to learn how to do this and to
then sort them by mailing address and street address and
put them into a mail merge. I have never used this type of
software and it may be impossible for anyone to show me
where to start. But...if anyone can, please do.
Thanks,
Donna Cornett
I have a column with First Name, then one with Middle
Name, then one with last name and then one with Suffix and
I want to put all them into one column. How do I do this.
I read the help and it says this:
=CONCATENATE(A2," ",B2) But it only shows two columns and
when I tried to add all four it gave me an error.
Can anyone help me? I need to learn how to do this and to
then sort them by mailing address and street address and
put them into a mail merge. I have never used this type of
software and it may be impossible for anyone to show me
where to start. But...if anyone can, please do.
Thanks,
Donna Cornett