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

2013-03-06 Thread Pravin Gunjal
good solution XLStime.. On Wed, Mar 6, 2013 at 4:06 PM, xlstime wrote: > 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 P

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 wrote: > =SUBSTITUTE(A1,CHAR(10)," ") > > > On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote: > >> >> Hi, >> >> I want to remove all enter. >> >> Regards, >> Kuldeep Singh >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce

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 wrote: > > Hi, > > I want to remove all enter. > > Regards, > Kuldeep Singh > >

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 wrote: > > 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 of this for