$$Excel-Macros$$ Re: Small Excel Issue formula

Hi Amar, Please paste the following formula in B2 =IF(ISERROR(MID(A2,SEARCH( ,A2,1)+1,LEN(A2)-SEARCH( ,A2,1))),A2,MID(A2,SEARCH( ,A2,1)+1,LEN(A2)-SEARCH( ,A2,1))) Note : Your formula is working fine i just made a change by checking if there is any error or not if it is then return value only

Re: $$Excel-Macros$$ Re: Small Excel Issue formula

Thanks Prince On Fri, Dec 28, 2012 at 5:13 PM, Prince prince141...@gmail.com wrote: Hi Amar, Please paste the following formula in B2 =IF(ISERROR(MID(A2,SEARCH( ,A2,1)+1,LEN(A2)-SEARCH( ,A2,1))),A2,MID(A2,SEARCH( ,A2,1)+1,LEN(A2)-SEARCH( ,A2,1))) Note : Your formula is working fine i