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
=CONCATENATE(J5,MONTH(K5),"/",DAY(K5),"/",YEAR(K5))
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate | Excel Worksheet Functions | |||
Concatenate | Excel Discussion (Misc queries) | |||
concatenate | Excel Worksheet Functions | |||
concatenate every second row to first row | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |