Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE-1
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE-1
Try
=Concatenate(J5,TEXT(K5,"DDMMYY")) "AYPCN" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate If | Excel Worksheet Functions | |||
Concatenate | Excel Discussion (Misc queries) | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
Concatenate | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |