Re: $$Excel-Macros$$ split text by pipe sign

2014-10-15 Thread Waseem Saifi
Wow ! It's epitome. thank you so much De Premor. On Wed, Oct 15, 2014 at 6:13 AM, De Premor wrote: > Try this > > =TRIM(MID(SUBSTITUTE($A15;"|";REPT(" ";99));(COLUMN(A1)*99)-98;99)) > > the idea is replacing a pipe char with 99 times white space using > SUBSTITUTE so we can trim it later to ge

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-14 Thread De Premor
Try this =TRIM(MID(SUBSTITUTE($A15;"|";REPT(" ";99));(COLUMN(A1)*99)-98;99)) the idea is replacing a pipe char with 99 times white space using SUBSTITUTE so we can trim it later to get the exact word then we break it a part every 99 char using MID function, and then remove the white space usin

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-13 Thread Vaibhav Joshi
cheers man... + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:46 PM, Waseem Saifi wrote: > thank you vaibhav, > > it's perfect > > On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > >> check this... >> >> + >> *I did not do this for

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-13 Thread Waseem Saifi
thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > check this... > > + > *I did not do this for you. God is here working through me for you.* > > On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi > wrote: > >> Hi Vaibhav, >> >> I want through formula. nor

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-12 Thread Vaibhav Joshi
check this... + *I did not do this for you. God is here working through me for you.* On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi wrote: > Hi Vaibhav, > > I want through formula. nor by text to column neither macro as already > mentioned it in attached file. In just one cell. > > On Sat,

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Waseem Saifi
Hi Vaibhav, I want through formula. nor by text to column neither macro as already mentioned it in attached file. In just one cell. On Sat, Oct 11, 2014 at 6:22 AM, Vaibhav Joshi wrote: > how do you want output? > > Formula or thru Macro? > > > > + > *I did not do this for you. God is here

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Vaibhav Joshi
check this..you can combine formula to get final result. + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 7:02 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi, > > Try text to column option. > > Regards, > > Swapnil > On 11-Oct-201

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Swapnil Palande
Hi, Try text to column option. Regards, Swapnil On 11-Oct-2014 10:19 am, "Waseem Saifi" wrote: > Hi Experts, > > I have attached a file which contain text in cell A15. I want to split > this text by pipe sign [|] in cells next to cell A15. > > Thanks in Advance. > > > Regards, > Waseem Saifi

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Vaibhav Joshi
how do you want output? Formula or thru Macro? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi wrote: > Hi Experts, > > I have attached a file which contain text in cell A15. I want to split > this text by pipe sign [

$$Excel-Macros$$ split text by pipe sign

2014-10-10 Thread Waseem Saifi
Hi Experts, I have attached a file which contain text in cell A15. I want to split this text by pipe sign [|] in cells next to cell A15. Thanks in Advance. Regards, Waseem Saifi -- 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