• Status: Solved
• Priority: Medium
• Security: Public
• Views: 366

# Excel - Unable to add next cell to existing cell - Combining multple cells in one row (Concatenate?)

Hi Experts,

When I drag my formula from b2 to b3, excetera, I was thinking the output would be combining the contens of a2, a3, a4.  But it doesn't combine the next cell.  My example explains it better.

Any ideas on how to correct this?

Thanks,
Byd2k

Column A                                              B
1 johnsmith@yahoo.com      "johnsmith@yahoo.com",
2 johnroberts@gmail.com      "johnsmith@yahoo.com","johnroberts@gmail.com"
3 janesmith@hotmail.com      "johnsmith@yahoo.com","johnroberts@gmail.com","janesmith@hotmail.com"
4 janesmith@live.com      At this point this cell should = b3 + a4
5 jane@prodigy.net                     At this point this cell should = b4 + a5

My formulas:
a1 ='s email address a2 is blank
b2 ='s =""""&A2&""","
b3 ='s =""""&A2&""","&""""&A3&""""
b4 ='s =""""&A2&""","&""""&A3&""""&","&""""&A4&""""

0
byd2k
• 2
• 2
1 Solution

Commented:
A sample workbook would be helpful, but it appears you have answered your own question pretty much:
"At this point this cell should = b3 + a4"
=B3&","&A4
and copy down.
0

Author Commented:

The formula must be added to each line.  I am trying to have Excel automatically add the &""""&A5,6,7,etc"""" when it's copied from b5 through b2000....

I wonder if this needs to be a vb code versus a formula.

-byd2k
0

Commented:
If you want the quotes added, it's just:
=B3&","""&A4&""""
and copy down. See attached file.
emails.xls
0

Author Commented:

I had to install a script and then it allowed me to use the following formua with Excel:

=concat(a2:a1000,"','")

byd2k
0

Commented:
rorya's works for me!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.