All articles with 'udf' Tag

Extract URLs from an excel spreadsheet cell using UDFs

Published on Jul 23, 2008 in hacks, Learn Excel, technology

Often my work involves processing web page data in excel sheets. This includes extracting the hyperlinks from cell contents. There is no formula for extracting hyperlinks though, you can right click on cell and choose “edit hyperlink” to see which address the cell is linking to. But that is a tedious process especially if you […]

Continue »

How to add a range of cells in excel – concat()

Published on May 28, 2008 in hacks, Learn Excel, technology

Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of cells with text which you want to add up to create a large text, you need to write an ugly looking biggish concatenate() or use […]

Continue »