Excel Tutorial
20120819
When is your date of birth?
1.
=MID(B3,FIND(CHAR(47),B3)-2,
10)
2.
=LOOKUP(9^9,MID(B4,ROW(
INDIRECT(“1:”&LEN(B4)-9)),
10)*1)
3.
=IFERROR(MID(B4,FIND("/",B4,1)
-2,10),"No DOB present")
4.
=MID(B4,FIND("/",B4)-2,10)
5.
=IFERROR(MID(B4,MIN(IFERROR(FIND({0;1;2;3;4;5;6;7;8;9;”/”},B4),”")),10),”")
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment