Hi friends suppose i have a data in
A1= U.S Buyer id: 525-554 DONE
What i wanna want in B2=525-554
so i tried this formula in B2 =MID(A1,FIND("id:",A1)+4,LEN(A1)-FIND("id:",A1))
but i am getting 525-554 DONE in B2....
I dont want the done..how can i customize it for getting just what i need i mean starting from 5 till a space is encountered...?? Or just till 7 count..??? Please show me d correct way.
Thanks,
rishi.ssh