How to delete strings of words from a range of cells

Solved/Closed
Arrissa
Posts
2
Registration date
Saturday June 14, 2014
Status
Member
Last seen
June 14, 2014
- Jun 14, 2014 at 01:33 PM
Arrissa
Posts
2
Registration date
Saturday June 14, 2014
Status
Member
Last seen
June 14, 2014
- Jun 14, 2014 at 06:53 PM
I have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells and its a slow moving process . I am not able to use the trim feature as not all websites start with http://.

Please help me with this. Any help will be appreciated. Thanks in advance.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 14, 2014 at 05:35 PM
why not do find and replace http:// with nothing ?
0
Arrissa
Posts
2
Registration date
Saturday June 14, 2014
Status
Member
Last seen
June 14, 2014

Jun 14, 2014 at 06:53 PM
Thanks a lot. This solved my problem.
0