Combine text from two or more cells into one cell after a formatted date

Posted on 2014-07-17
Last Modified: 2014-07-17
I am attempting to create a spreadsheet to create source citations for my genealogy. Everything works great until I try to "& &" after a formatted date. I am forced to split my citation across multiple cells, but it makes for bulky exporting of my citations. Is there a way to bring columns V and Columns W together in the example spreadsheet that I included?

Any help would be greatly appreciated!
Question by:Mada123
    LVL 7

    Accepted Solution

    Use the in-built CONCATENATE function. Example in V3:
    =CONCATENATE(B3, " U.S. Census, ", D3, " County, ", E3, ", population schedule, ", C3, ", Enumeration District (ED) ", F3, ", sheet ", G3, ", p. ", H3, ", dwelling ", I3, ", family ", J3, ", ", L3, ", (age ", M3, "), line ", K3, ", ", N3, " ", P3, " ", O3, "; digital image, <i></i>, citing National Archives microfilm publication ", R3, ", roll ", S3, ", ( : accessed ", TEXT(Q3, "dd mmmm yyyy"), T3, "; citing National Archives microfilm publication ", R3, ", roll ", S3, ".")

    Open in new window


    Author Closing Comment

    Works perfect! Thanks so much!
    LVL 7

    Expert Comment

    by:Raghu Mutalikdesai
    Good to hear it helped you! Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    794 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

    16 Experts available now in Live!

    Get 1:1 Help Now