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
Is there an Excel Function that can be used in lieu of this formul	5	Jul 13, 2009
CONCATENATE	2	Mar 9, 2005
revise CONCATENATE code	2	Feb 11, 2013
How do you set up a month of supply formula?	1	Jan 24, 2007
Help !!!	2	Jan 10, 2010
Text Next Line	2	Mar 10, 2005
@IF Formula	3	Jun 24, 2009

Ask a Question