Results 1 to 4 of 4

Thread: Concatenate with different date formats

  1. #1
    Board Regular
    Join Date
    May 2016
    Posts
    121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Concatenate with different date formats

    I use concatenate to create a code so I can use vlookup. The source of data comes from 2 separate sheets. The issue is I get two different result using concatenate (i.e. formula = concatenate (A1,B1) which is the date,client's surname. The two different results from the two sheets are:
    43369Lake
    01/08/2019Lake

    This means I can't use vlookup as the codes come out differently. I need to know concatenate formula to get the codes in the same format so vlookup will work. The columns with the dates both say they are in date format.

    So just need to be able to convert the date (via formula using concatenate) in one of the sheets so it's the same as the other)

    Thanks in advance

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,967
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Concatenate with different date formats

    Try this

    ABC
    1
    201/08/2019Lake01/08/2019Lake
    3

    Hoja4



    Worksheet Formulas
    CellFormula
    C2=TEXT(A2,"dd/mm/yyyy") & B2

    Last edited by DanteAmor; Aug 28th, 2019 at 12:32 AM.
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    May 2016
    Posts
    121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate with different date formats

    Thanks!!!

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,967
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Concatenate with different date formats

    Youre welcome & thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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