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