Remove All Data After /

Question:
I have list of domains in excel I would like to delete all the subfolders without going in one by one is there a way to do?

example:
www.domain.com/subfoldername
www.domain2.com/subfoldername

my list has about 300 domains how can I delete everything after the forward slash?

Answer:
There are a few solutions to this problem but probably the easiest and quickest is to use the Replace function.
See the steps below for a full step by step guide.

Step 1

Replace Data1
Select all the cells containing the data you want to change.

Step 2

Replace Data2
Select the Home tab
In the Editing group click the Find & Select command.
Select Replace from the dropdown list.

You can also use the keyboard shortcut: Ctrl + H

Step 3

Replace Data3
In the Find what: box type /*
This tells Excel to find the character /.
The * represents a wildcard which tells Excel all the data after the /

Leave the Replace with: box blank as all we want to do is delete the data.

Click Replace All.

Example

Replace Data Sample







Be the first to comment

Leave a Reply