101 Tip & Trik
Wednesday, October 26, 2011
Display Date in two digit Excel to mySQL
=YEAR(L5)&"-"&IF(LEN(MONTH(L5)) = 1,CONCATENATE("0",MONTH(L5)),CONCATENATE("",MONTH(L5)))&"-"&IF(LEN(DAY(L5)) = 1,CONCATENATE("0",DAY(L5)),CONCATENATE("",DAY(L5)))
Thursday, October 13, 2011
Find String in Cell
If
InStr("Look in this string", "look")
= 0 Then
MsgBox "woops, no match"
Else
MsgBox "at least one match"
End If
End Sub
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)