Category Archives: Macros

How to extract a URL from a hyperlinked image, graphic, or icon on Excel

When you copy and paste data from the Web onto an Excel spreadsheet, you sometimes end up copying and pasting images, graphics, or icons that were originally hyperlinks. To make the data usable, you may want to extract just the hyperlink and get rid of the image, graphic, or icon. You have two options. First […]

Posted in Macros | Leave a comment

How to capitalize the first word in a string (or the first letter in a cell) using an Excel macro instead of an Excel function or formula

Although you can use a Microsoft Excel function or formula to capitalize the first word in a string (or the first letter in a cell), there are times when you may want to change the case of the text in the same cell the data was entered, programmatically. Just follow these steps: 1. Hit [ALT]+[F11] to […]

Posted in Macros | Leave a comment

How to uppercase text using an Excel macro instead of the UPPER function

Although you can use the =UPPER() function or formula to lowercase all the text in a cell, there are times when you may want to uppercase the text in the same cell the data was entered, programmatically. Just follow these steps: 1. Hit [ALT]+[F11] to open the Visual Basic Editor 2. Hit [ALT]+[I]+[M], or just click “Insert” > […]

Posted in Macros | 2 Responses

How to lowercase text using an Excel macro instead of the LOWER function

Although you can use the =LOWER () function or formula to lowercase all the text in a cell, there are times when you may want to lowercase the text in the same cell the data was entered, programmatically. Just follow these steps: 1. Hit [ALT]+[F11] to open the Visual Basic Editor 2. Hit [ALT]+[I]+[M], or just click “Insert” […]

Posted in Macros | Leave a comment

How to capitalize all words using an Excel macro instead of the PROPER function

Although you can use the =PROPER () function or formula to capitalize all the words in a cell, there are times when you may want to capitalize the text in the same cell the data was entered, programmatically. Just follow these steps: 1. Hit [ALT]+[F11] to open the Visual Basic Editor 2. Hit [ALT]+[I]+[M], or just […]

Posted in Macros | 1 Response

How to remove all hyperlinks in an Excel file

Looking to remove all the hyperlinks in an Excel file? Hit [ALT]+[F11] to open the Visual Basic Editor Go to “Insert” > “Module” and in the pop-up window copy: Sub RemoveHyperlinks() ‘Remove all hyperlinks from the active sheet ActiveSheet.Hyperlinks.Delete End Sub Then click “File” > Close and return to Microsoft Excel You can now run […]

Posted in Macros | 2 Responses

How to extract a URL from a hyperlink on Excel

Today, I faced the problem of extracting URLs from a long list of hyperlinked text. I had two options: First is to do it manually: Right-click a hyperlink. From the Context menu, choose Edit Hyperlink. Excel displays the Edit Hyperlink dialog box. Select and copy (Ctrl+C) the entire URL from the Address field of the […]

Posted in Macros | 196 Responses