Delete after dot

[Serdarrk]

Hello,

İn attached file there are numbers in A column. I need to delete numbers after ''.'' . But some rows have . and 2 number some have . and 1 number and also some dont have number. How can I fix it?

https://www.dropbox.com/s/5mlelkrupfg9ywn/Yeni Microsoft Office Excel Çalışma Sayfası.xls?dl=0

 

[frank_AL]

If you want to replace the value in the same cell it would require a VBA macro.

If you can accept the modified value in another cell, place the formula below in cell B1 (or any other Column) and copy down;
=IF(ISNUMBER(SEARCH(".",A1)),LEFT(A1,FIND(".",A1)-1),A1)

 

[Serdarrk]

Thank you for your interest and help.