Remove the latter part of a cell contents after a specific string

[mmenashe]

I have a lot of work to sort through

some sites are:

http://www.example.com

and others are

http://www.example.com/4545cfds6d2

what I want to do is find a way to axe the "/4545cfds6d2" from my column of websites

the common occurence is that all of these have a .com/, whereas the ones I dont have to do anything with are just .com at the end

thanks

Matt

edit, of course its not 454cfds6d2, but a random type of info, so I cant just have it replace that

 

[Michael M]

Matt
Try

=LEFT(A1,FIND(".com",A1)+3)

 

[schielrn]

Can you just use find and replace?

Press Control+H to bring up find and replace.

Find: .com*
Replace: .com

This saves time of using a formula and then having to paste it back over your old data. You could probably even record a macro using this too.

Hope that helps.

 

[mmenashe]

Michael, youre the man, way to go

actually I came up with a very inelegant solution also, which Ill post here just to add to the stockpile of great answers

I exported that set of data to a .txt file, reimported it with / as the delimiter and then chopped off those last few columns and put it back together

probably the totally wrong way to go about it, but it worked also