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
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
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
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
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,
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
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
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
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 [
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