CONCATENATE 1

Guest · Mar 9, 2005

J5
HFUP,

K5
031005

L5
=CONCATENATE(J5,K5)
HFUP,38421 how can i get this date corrected to show what is in K5 tryed
formating cell to mmddyy

thanx

Gap · Mar 9, 2005

=CONCATENATE(J5,MONTH(K5),"/",DAY(K5),"/",YEAR(K5))

Date CONCATENATE	2	Mar 10, 2005
CONCATENATE	2	Mar 9, 2005
Is there an Excel Function that can be used in lieu of this formul	5	Jul 13, 2009
Help !!!	2	Jan 10, 2010
revise CONCATENATE code	2	Feb 11, 2013
Text Next Line	2	Mar 10, 2005
@IF Formula	3	Jun 24, 2009
COPY FORMULA TO THE LAST CELL	2	Feb 12, 2008

Ask a Question