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
Select all the cells containing the data you want to change.
Step 2
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
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.
Leave a Reply
You must be logged in to post a comment.