Texts and Strings – Page 3

MID + SEARCH to convert cell to rows

January 23, 2012 ANmar No Comments

I have been there and done that more than once before This time I had a really large cell, more than 3k characters need to be converted into rows, and here is how you can do it. This one uses MID with SEARCH to do that Use one column to get the character number of…

MID, SEARCH, Standard functions, STRING, Texts and Strings

Hyperlink usage and HyperlinkOf UDF

January 21, 2012 ANmar No Comments

The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user to certain area. Of course the “Jump-to” link need other functions, like Match, Indirect and Index Here is a sample of what we can do…

CELL, Formulas - combined functions, HYPERLINK, HyperlinkOf, Information, Lookup and References, MID, Standard functions, User-Defined f(x)s = UDF