$$Excel-Macros$$ Re: Need Urgent Help regarding Text to column

2009-03-07 Thread tariq 78692
achully this is font error 2009/3/5 Lavprasad Kori lavprasa...@gmail.com Dear All, Please help me. Attaching herewith the downloaded data. I want to do just text to column. But when I do this, the data after special character (Square) has been deleted. -- Thanks Regards,

$$Excel-Macros$$ Re: Need Urgent Help regarding Text to column

2009-03-07 Thread Ashish Jain
Hi Tariq, This is not a font problem, those square boxes are newline characters which don't need any font. - Lavprasad Did you tried Clean function? It should work. I hope Clean(A1) should work to remove such characters. For more tips, tricks, downloads and problem solutions: visit --

$$Excel-Macros$$ Re: Need Urgent Help regarding Text to column

2009-03-06 Thread r...@vi k...@r
=clean(a:a enter On 3/5/09, Lavprasad Kori lavprasa...@gmail.com wrote: Dear All, Please help me. Attaching herewith the downloaded data. I want to do just text to column. But when I do this, the data after special character (Square) has been deleted. -- Thanks Regards, Lavprasad