How to split text to columns from newline?

TFS1990 

To search for external links in an Excel workbook, you can use the "Edit Links" feature. Here are the steps:

1. Open the Excel workbook that you want to search for external links.
2. Go to the "Data" tab in the Excel ribbon, and click on "Edit Links" in the "Connections" group.
3. The "Edit Links" dialog box will open, which shows all the linked workbooks that are used in the current workbook. This dialog box will show you all the external links as well as the internal links.
4. To see only the external links, click on the "Status" column heading to sort the links by status. External links will have a status of "Source not found" or "Error".
5. If you want to update or change an external link, select it and click on the "Change Source" button.
6. If you want to break an external link, select it and click on the "Break Link" button.

By following these steps, you can easily search for external links in your Excel workbook and manage them as needed.

About your link:

You can find external links in an Excel workbook by using the Find and Replace feature.

Here are the steps to do so:

1. Select all the cells in your workbook.
2. Go to the Home tab –> Editing –> Find & Select –> Find.
3. In the Find and Replace dialog box, enter *.xl* in the ‘Find what’ field.
4. Click on Find All.

This will find and show all the cells that have external links in them.

Hope it helps you!