I was looking for any formula or VBA code to separate Name and DOB from raw data please help.
S ShoaibAli New Member Feb 28, 2020 #1 I was looking for any formula or VBA code to separate Name and DOB from raw data please help. Attachments Format.xlsx 8.4 KB · Views: 7
GraH - Guido Well-Known Member Feb 28, 2020 #2 Try, [B2]=LEFT(A2,FIND("/",A2)-1) [C2]=MID(A,LEN(b2)+3,10)
S ShoaibAli New Member Feb 28, 2020 #3 Please also answer this question I want to extract name and ID's as attached in File. Attachments Format.xlsx 8.3 KB · Views: 6