Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2014-07-17
Medium Priority
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
  • 2

Accepted Solution

Raghu Mutalikdesai earned 2000 total points
ID: 40203741
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>Ancestry.com</i>, citing National Archives microfilm publication ", R3, ", roll ", S3, ", (http://www.ancestry.com : accessed ", TEXT(Q3, "dd mmmm yyyy"), T3, "; citing National Archives microfilm publication ", R3, ", roll ", S3, ".")

Open in new window


Author Closing Comment

ID: 40203748
Works perfect! Thanks so much!

Expert Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

581 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