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

Posted on 2011-10-05
Last Modified: 2012-05-12
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?


Column A                                              B
1      "",
2      "",""
3      "","",""
4      At this point this cell should = b3 + a4
5                     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&""""

Question by:byd2k
    LVL 85

    Accepted Solution

    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"
    and copy down.

    Author Comment

    Thanks for the reply.  

    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.

    LVL 85

    Expert Comment

    by:Rory Archibald
    If you want the quotes added, it's just:
    and copy down. See attached file.

    Author Comment

    I found a site:

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


    Thanks again for your assistance,
    LVL 4

    Expert Comment

    rorya's works for me!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now