Fortunately, there's the WayBack Machine: Īs can be noted in the comments, you may need to change 'SHEET 1' to 'Sheet1' when using the CELL_URL() function. That tells the function to extract the URL from the cell from one column less than the current position.Then, drag the formula from 'CELL C5' to 'CELL C24', where your links end. Or, another example, assuming that you have a single column of 20 links, starting from 'CELL B5' on 'SHEET 1', and that you want the URL to be in the column next to it (thus, starting from 'CELL C5'), in 'CELL C5', enter the formula as follows: =CELL_URL('SHEET 1', ROW(), COLUMN()-1). Then, you can drag that formula according to the dimensions of your data. Now, you have access to a macro titled 'CELL_URL' which you can use as follows:Īssuming that your links start in 'CELL A1' on 'SHEET 1', I recommend you go to a new sheet, and in the first cell, enter: =CELL_URL('SHEET 1',ROW(),COLUMN()). Under 'My Macros' select 'Module 1' and click on 'Edit'.

Hit Export vCard Now button and in a few minutes, Excel contacts.

Also, select contact exported into single vCard file. Use the Browse button and set destination to save VCF file.

Check Excel contacts in preview panel and map contacts accordingly.

Press ALT + F11 to open your macros organizer. Add Excel file that you want to convert by using the Browse button.

If you haven't had experience with macros, here are the steps involved:

Openoffice calc convert text to number