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.

How to delete strings of words from a range of cells
Excel if range of cells contains specific text ✓ - Excel Forum
How to delete whatsapp contact not in address book - Guide
How to delete whatsapp account without phone - Guide
How to delete a hacked facebook account without password - Facebook Forum
Delete fake facebook account within 24 hours ✓ - Facebook Forum

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jun 14, 2014 at 05:35 PM

why not do find and replace http:// with nothing ?

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.

Subscribe To Our Newsletter!