Hi Rajesh,
Please see another way of doing the Same:
=MID(A2,1,FIND("*",SUBSTITUTE(A2," ","*",1),1)) in Cell B2
=SUBSTITUTE(A2,B2,"") in Cell C2
On Thursday, December 27, 2012 4:40:50 PM UTC+5:30, rajeyssh wrote:
>
> Dear Sir
> I want to split column a into column b and c according to their hea
Hi Rajesh,
Please Apply :
=RIGHT(A2,11) in Cell C2 and drag Down up to last Row
=SUBSTITUTE(A2,C2,"") in Cell B2 and drag Down up to last Row
Note: But first write formula in Cell C2 :)
Regards
Prince
On Thursday, December 27, 2012 4:40:50 PM UTC+5:30, rajeyssh wrote:
>
> Dear Sir
> I want
