Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-06 Thread Mahesh
Hi, save the number as text may help u. On Tue, Jul 6, 2010 at 1:20 PM, Iqbal Muneeb wrote: > Thanks for your reply. That is what I am doing and it is combersome. What > I want to know is as follows > 1.ithere some VBA codes whereby the capacity can be enhanced from 255 > charachters; or Excel

Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-06 Thread Iqbal Muneeb
Thanks for your reply. That is what I am doing and it is combersome. What I want to know is as follows 1.ithere some VBA codes whereby the capacity can be enhanced from 255 charachters; or Excel 2010 would solve this problem ( I have Excel 2007). -- Have a good day! Muneeb Cell: 0300 2213043 -

Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-05 Thread Aindril De
Sorry for the Typo please read "text filter with Containg option" as"custom text filter with * contains* option" Regards, Andy On Mon, Jul 5, 2010 at 5:59 PM, Aindril De wrote: > Hi Iqbal, > > I don't know the way out. > However, though it does not show up because of its length, you can still d

Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-05 Thread Aindril De
Hi Iqbal, I don't know the way out. However, though it does not show up because of its length, you can still do a text filter with Containg option and search for something unique in that string to show that up in the result. Regards, Andy On Mon, Jul 5, 2010 at 5:04 PM, Iqbal Muneeb wrote: > H

$$Excel-Macros$$ Cell Capacity & filters

2010-07-05 Thread Iqbal Muneeb
Hi Dear ones. I need help. Cells have a capacity of 255 characters, beyond which filters do not work. Is there a wayout. I have a file where certain cells have very long strings; they donot show up in the filter. Please guide me. Thanks. -- Have a good day! Muneeb Cell: 0300 2213043 -- --