0
How do you combine two columns of email addresses into one column?
Wiki User
∙ 14y ago
Without writing a custom macro, here are two ways you can combine two columns of any kind of data into one column. Assume your first column is in A, the second column in in B, and all data starts in row 1. In cell C1 enter one of these formulas:
- =A1 & " " & B1
- =concatenate(A1, B1)
Then, copy the formula to all cells in column C that correspond with entries in columns A and B.
The advantage of the first formula is that you can include a separator between the two entries: " " gives you a space; " - " gives you a dash with spaces on both sides. If you want to join the two columns without anything between the two entries, just use =A1&B1.
If you mave more than two columns, use the same sequence to combine more cells.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
what does addresses do in email?
In addresses you have email addresses of people that you have emailed before.
Are email addresses cap sensitive?
No, email addresses are not cap sensitive.
What country has email addresses ending in no?
Norway is the country that has email addresses ending with .no.
Why are email addresses always in small caps?
All email addresses are in small caps, as are all internet addresses. If you are typing internet or email addresses in large caps, you are in fact "doing it wrong".
Where are email addresses with the suffix 'be' located?
Email addresses with the suffix 'be' are located in the country of Belgium. The email addresses with the stuffix 'be' domain became active in the year 1989.
Sports media email addresses?
How do you find the email addresses of Sports Illustrated writers?
What are the email addresses for Comcast executives?
http://consumerist.com/consumer/executive-customer-service/email-addresses-for-comcast-executives-320438.php There are plenty email addresses there.
What does prior email addresses means?
Any email addresses used before the one you are using now.
What is Eminem email?
his email addresses is ymabruce@gmail.com ymabruce123@gmail.com and ymabruce123@aol.com
How do you email people on WikiAnswers?
WikiAnswers' users email addresses are not public. However, there are some users who post their email addresses in their bio.
Why do email addresses end .co.uk?
Email addresses end in .co.uk when they are supported by a provider in the United Kingdom.
What are the email addresses of Northwestern Mutual Executives?
wiki answers never gives out any email addresses
