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 d...@premor.net 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

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

2014-10-14 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 waseemsa...@gmail.com wrote: thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi v...@vabs.in wrote: check this... + *I

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 using

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 v...@vabs.in 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 waseemsa...@gmail.com wrote: Hi Vaibhav, I want

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 waseemsa...@gmail.com wrote: Hi Vaibhav, I want through formula. nor by text to column neither macro as already mentioned it in attached file. In just one

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 waseemsa...@gmail.com wrote: Hi Experts, I have attached a file which contain text in cell A15. I want to split this

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 waseemsa...@gmail.com 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,

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-2014 10:19

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 v...@vabs.in wrote: how do you want output? Formula or thru Macro? + *I did not do this for you. God is

$$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