+ Reply to Thread
Results 1 to 4 of 4

concatenate date with numbers

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    concatenate date with numbers

    I'm having trouble with concat.

    The data I want to concatenate is comprised of a date and two values. When I formulate the function as I've done in the past, it doesn't produce what I'm expecting

    I've attached a small worksheet which shows how the existing data is formatted, and to its right, my desired formulation.

    I've tried various formulas along with Concat such as Text, but this results with the date being presented with the 5 digit date number rather than text.

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: concatenate date with numbers

    hi there. how about:
    =CHAR(34)&TEXT(A3,"yyyy-mm-dd hh:mm:ss")&CHAR(34)&","&B3&","&C3

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    483

    Re: concatenate date with numbers

    Or a shorter one:

    =TEXT(A3,"\""yyyy-mm-dd hh:mm:ss\"",")&B3&","&C3

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: concatenate date with numbers

    also you can try with PowerQuery (Get&Transform)

    add prefix, suffix, merge columns with comma as separator
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate a date field keeping the date format
    By rrcrossman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2016, 04:28 PM
  2. Replies: 14
    Last Post: 07-24-2014, 02:20 PM
  3. concatenate Text and numbers
    By Mike1w in forum Excel General
    Replies: 1
    Last Post: 11-06-2007, 04:55 PM
  4. [SOLVED] [SOLVED] I know how to concatenate ,can one de-concatenate to split date?
    By QUICK BOOKS PROBLEM- in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2005, 01:05 PM
  5. Format numbers / Concatenate
    By dbizek in forum Excel General
    Replies: 4
    Last Post: 06-23-2005, 02:05 PM
  6. [SOLVED] concatenate with numbers
    By Ciara in forum Excel General
    Replies: 2
    Last Post: 05-31-2005, 10:05 AM
  7. Concatenate text and numbers?
    By sunslight in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1