Date CONCATENATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

so the final resualt should show
HFUP,031005

thanx
 
Use the TEXT function (and don't bother using the CONCATENATE function, you
can use &s instead):

=J5&TEXT(K5,"mmddyy")

If you indeed want a comma separating them (your formulas below wouldn't
show a comma), you can stick it right before the mmddyy part.
 
Back
Top