Re: $$Excel-Macros$$ Remove All Enter..............

2013-03-06 Thread The Viper
=SUBSTITUTE(A1,CHAR(10), ) On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, I want to remove all enter. Regards, Kuldeep Singh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

Re: $$Excel-Macros$$ Remove All Enter..............

2013-03-06 Thread xlstime
another way press Ctrl+H in find what enter Alt+ 0+ 1+ 0 (press alt then 0 (zero) then 1 (one) then 0 (Zero) and replace all . Enjoy Team XLS On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, I want to remove all enter. Regards,

Re: $$Excel-Macros$$ Remove All Enter..............

2013-03-06 Thread Pravin Gunjal
good solution viper.. On Wed, Mar 6, 2013 at 3:51 PM, The Viper viper@gmail.com wrote: =SUBSTITUTE(A1,CHAR(10), ) On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, I want to remove all enter. Regards, Kuldeep Singh -- Are you =EXP(E:RT) or