Hello All,
I have new query..in col J i have date. in col I i have some Text's..
Col I
CG D2 42
GN 01 82
Col J
1/1/2002
12/1/2014
I'm trying to use concatenate this two...in col H. But in my "left" code, it picks up "1" instead of "01"...
and hence giving me a wrong output..like..
CG D2...