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
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
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
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
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
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
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,
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
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
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
10 matches
Mail list logo