How to delete characters after a value in a cell?

[mkabwilliams]

I've got a list of url's in excel that I need to delete everything
after the .com could someone tell me how to do this? I'm running excel
2007

 

[Max]

One way, in say B1, copied down: =LEFT(A1,SEARCH(".com",A1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[RyanR]

Max's method will return everything upto the .com, e.g. www.someplace.com.au
becomes www.someplace

=LEFT(A1,SEARCH(".com",A1)+3) will return including the .com, such that
www.someplace.com.au becomes www.someplace.com

The reason being, search() returns the starting character of the search
string.

HTH

 

[Dave Peterson]

Another way:

Select the range to fix
Edit|replace
what: .com* (the asterisk is a wild card)
with: .com (or .COM or any upper/lower case you want)
replace all

 

[Max]

Agreed, my error. Thanks for correction.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik