Concatenate Date and Text

Topic

New Reply

Hi There

I am trying to combine data from in two different Columns into one. One column is a date and the other is text. When I do this using =CONCATENATE(F2,” “,J2) the result is 42066 Smith when I want 03/03/2014 Smith

What am I doing wrong?

Kerry:mellow:

Reply | Quote

Replies

Dates are actually numbers so you need to convert the date to text before concatenation. You could do something like this:
=concatenate(day(F2),”/”,month(F2),”/”,year(F2),” “,J2)

cheers, Paul

Reply | Quote

You can also use the TEXT function:
=CONCATENATE(TEXT(F2,”dd/mm/yyyy”),” “,J2)

Reply | Quote

Hi

..why waste time typing CONCATENATE when you can just use

=TEXT(F2,”dd/mm/yyyy “)&J2

Note: I have included the ‘space’ separator within the TEXT format to be used.
For example, if you wanted the date, then a space, then the character ; and then another space and then the name, you would use
=TEXT(F2,”dd/mm/yyyy ; “)&J2

zeddy

Reply | Quote

Also

=TEXT(F2,”mm/dd/yy”)&” “&J2

Reply | Quote

Also

=TEXT(F2,”dddd mm/dd/yy “)&J2

zeddy

Reply | Quote

One of my first attempts at contributing. Would a User Defined Function be appropriate?

Public Function DText(dDate As Date, sRange As String) As String
DText = dDate & ” ” & sRange
End Function

Enter the formula =DText(F2,J2) into the cell

Alex

Reply | Quote