Except it does not work if the text is over 255 ( I note That is basically what my Excel seems to do anyway if the text “looks” like a URL. In brief an Events ( Worksheet_Change ) Program sets off a code that will change a text in a cell to a hyperlink. The best I have is a modification of a VBA solution workaround which someone did. įurther it appears not possible to change a cell value with a Function, so another often suggested approach, using a User Defined Function, UDF, also fails at that fundamental point. ( As it is actually the “255” that Excel “sees” that is the problem, you cannot seem to do any splitting then joining as suggested here, as Excel still ends up “seeing”. Fundamentally there does not seem to be a workaround to get over the 255 Formula limit. I never managed to do any formula to get over the problem. So I thought it would be a benefit to others if i dropped off one solution that I now have. But, ( I guess due to the well descriptive Title ) I kept hitting on this Thread toime and time again while I was searching!!!. This Thread did not help too much as no solutions in it worked. I was looking at a similar problem just recently.
