Getting error on exceeding some specific limit char

Originally Posted by haroon_shah

Hi,
Can anybody help me as i am doing three dimensional excel sheet and its working as i have import sheet where i write my test cases and thier is another sheet i created where i put the function below where i can pass/fail the bugs and when i click any test case in that sheet it bring me to specific test case on Import Sheet.

=IF(NOT(ISBLANK(Template!C346)),HYPERLINK(CONCATENATE(SummarySheet!$B$2,"ImportSheet!",CELL("address")), Template!C346),"")

Now the problem is when i exceed some length of characters in Import Sheet i get error on that work sheet where is the above formula.

Error: #VALUE!

I think as i am not sure can be that the problem of exceeding 255 Char in one cell. is there a solution for that?

I will be really thankful.

Cheers

Hi,

your error occurs when C346 exceeds 255 characters, and is (sort of) confirmed at http://groups.google.com.au/group/mi...33dac9f66aed9c

the #Value error can be avoided for testing purposes by using Left(C346,255) but that (or course) destroys the link.

Solution is to keep C346 below 256 characters.

hth
---

Originally Posted by haroon_shah

thanks Bryan Hessey.. Can you tell me as u mentioned i can do

"the #Value error can be avoided for testing purposes by using Left(C346,255)"

What you mean by that?

how can i do that?

Hi,

to test the formula (but not the Data), you can use the first 255 characters, BUT the link is then incomplete, it's missing the rest of the characters.

You then need to fix the data to be within the required limit.

hth
---