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[TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl63, width: 163"]My lat issues are
[TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]434.011400[/TD]
[/TR]
</tbody>[/TABLE]
i need to get rid of the 4 in 434
Any ideas!??? I have been searching for hours! [/TD]
[/TR]
</tbody>[/TABLE]
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 ...