Remove last 19 characters from a field

[viper20]

Hey Everyone,

I am a total excel noob how can i remove the last 19 characters from a field for example:

<table width="652" border="0" cellpadding="0" cellspacing="0"><col width="652"><tr height="20"> <td style="height:15.0pt;width:489pt" width="652" height="20">http://www.google.com,random14,hello532,

how would i remove everything after the "m" in the .com?

i have a bunch of fields i need to do this for they are all different sizes but the last 19 characters in all them need to be removed how could i accomplish this?

Thanks
</td> </tr></table>

 

[trunten]

Lets pretend that was in cell A1. You could put this formula in B1:

=RIGHT(A1,19)

 

[viper20]

ok i did exactly that, and that just returns the value i want to get rid of (the last 19 characters) i want the formula to return everything except the last 19 characters so in the example i provided i want it to return only
http://www.google.com

Thanks

 

[barry houdini]

Assuming there are always at least 19 characters in A1 try using

=LEFT(A1,LEN(A1)-19)

 

[Biz]

Maybe

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

Biz

 

[viper20]

Assuming there are always at least 19 characters in A1 try using

=LEFT(A1,LEN(A1)-19)

Hey Barry,

this works great thanks!

Now another dumb question how do i apply this formula to all the 580 fields i need to apply this for?

Thanks so much for all your help everyone

 

[viper20]

Nevermind i figured out how to apply the fomula to the entire sheet

Thanks again guys