Excel batch find and replace specific text in hyperlinks
In Excel, you can batch replace a specific text string or a character in cells with the another one by the Find and Replace function. However, in some cases, you may want to find and replace a specific text in hyperlinks, excluding other formats of contents as below screenshot shown. Actually, the Find and Replace function can handle this job too in Excel.
1. Select the cells of range that you want to batch find and replace in hyperlinks, then press Ctrl + H to display the Find and Replace dialog.
2. In the popping Find and Replace dialog, click Options to expand the dialog.
3. Click Format on the Find what line to enable the Find Format dialog.
4. Then under Font tab, choose Single option from the drop-down list of Underline in the Find Format dialog.
5. Click OK to back to the Find and Replace dialog, in Find what textbox, type the string or character you want to find, and in the Replace with textbox, type the new string you use.
6. Click Replace All, a dialog pops out for reminding how many cells done. Click OK to close it, and then close the Find and Replace dialog.
Batch convert hyperlinks to text contents or extract hyperlinks from cells
|
| If you want to replace the cell contents with the hyperlink addresses, you can choose the Cell contents replace hyperlinks addresses option in Convert Hyperlinks utility of Kutools for Excel, if you want to extract all hyperlinks from a range of cells, chose the Hyperlink addresses replace cell contents option. Click for 30 days free trial! |
 |
| Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |
Quickly create a hyperlink to specific worksheet in another workbook
In Excel, we can create a hyperlink to a web address to quickly open the website by clicking, but have you ever tried to create a hyperlink to a specific worksheet in another workbook? In this article, you may find the solution.
Create a hyperlink to a chart in Excel
In Excel, creating a hyperlink is easy for most of users, but have you ever tried to create hyperlink to a chart in Excel which means that click at a value and then link to a chart in another sheet? Generally, there is no way to directly create a hyperlink to a chart, but here, in this article, I can introduce an interested way to solve it.
Prevent/disable automatic hyperlinks in Excel
As we all known, Excel create clickable hyperlinks automatically when we input the web addresses into cells. Maybe, sometimes, this is somewhat annoying. Today, I will introduce some quick tricks for you to prevent automatic hyperlinks in Excel.
Convert multiple email addresses to hyperlinks in Excel
If you have a list of plain text email addresses in a worksheet, and now, you want to convert theses email addresses to hyperlinks that you can send emails while clicking the addresses. Of course, you can convert them to hyperlinked email addresses, but, this method will be boring if there are multiple addresses needed to be converted. In this article, I will talk about some good tricks to deal with this task.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
