deleting a number BEFORE the decimal

[cartogal]

Hey all, I am trying to format my lat and longs in order for Fusion Tables to be able to geocode them. I have it down to where I have separated the lat and longs into their own column.
I started with this
>Point><coordinates>-77.056124,35.552686,0.0</coordinates></Point>

my long issues are -78.335,35 i need to get rid of ,35

My lat issues are 434.011400 <tbody> </tbody> i need to get rid of the 4 in 434 Any ideas!??? I have been searching for hours!

<tbody>
</tbody>

Niki

 

[kevatarvind]

Hi And Welcome To The Mr Excel Board

Can you post some more data with desired result ?

 

[shg]

For the first, select the column and replace ,* with nothing

For the second, you could a formula in an adjacent column: =MOD(A1, SIGN(A1)*100)

 

[cartogal]

I need it to just be for example 35.265492 in one excel column and -77.296587 in another.
thanks!

 

[cartogal]

Thanks so much shg!!!!!!!!!!!!! That did it!!!! You saved me hours of time and much frustration!!!

 

[cartogal]

thanks for replying kevatarvind!

 

[shg]

You're welcome.

For the second, you use could a formula in an ...