Custom Function in Excel to get the url of the cell

i am working on small excel project to get the url

i copy the links from the webpage straight into excel
well the url or hyperlink its there but the problem is...
i need to insert them into mysql database and...
there are 10,000 records.


































i am still using office 2007 don't whether the function is available in the newer versions..


so here are the steps for ppl using excel 2007..........

open a macro enabled workbook or save it later as .xlsm


Alt + F11 open the visual basic editor

insert a new module

paste the following code (highlighted in yellow)


Function GETURL(HyperlinkCell As Range)

 GETURL = HyperlinkCell.Hyperlinks(1).Address

End Function

save and close the editor

now go back to the sheet view

Excel Fills Gaps in Data

 as you can see there gaps in the excel data that i need to upload into the mysql database

 i added this function =IF(D23="",E22,D23)

Creating Pivot Charts in Excel

well creating charts in excel is very very easy, I am using Microsoft Excel 2007.. yeah yeah its kinda old..

i never tried it in Open Office.. hmm....hmm..well.this is my data for my example....

click the under "Insert; tab click the "Pivot Table" icon, you will get a dropdown,
select the "Pivot Chart"

here's a better look :)

Once you click you'll get a popup

You get this.. well i left the default options as it is....

now lets create that Chart..
lets go the "PivotTable Field List"

click the one field, you'll get a column in the sheet.. mAGiKaL!!!! :))

the chart....