Delete characters

[rickbw]

If I have a cell like "AAI.O" and another cell "KK.D" and I wanted to remove the period and anything after it, result in another cell would be "AAII" and "KK" in adjacent cells, is there a function that would allow me to accomplish it?

 

[rickbw]

Above is visual of what I am attempting to accomplish

 

[Hany ali]

please Upload the Excel File ?

 

[rickbw]

Example file attached

 

[rahulshewale1]

HI @richbw,

See if is ok ?
CELL B2 Copy Down
=IFERROR(MID(A2,1,FIND(".",A2)-1),A2)

 

[Fluff13]

Another option
=REPLACE(A2,FIND(".",A2&"."),LEN(A2),"")

 

[rickbw]

Thank you! Both responses worked.

 

[Fluff13]

You're welcome & thanks for the feedback.

 

[bosco_yip]

Another option :

=LEFT(A2,FIND(".",A2&".")-1)

Regards

 

[shrivallabha]

If you are going to do it once then you can also try find and replace as shown below (Replace with is completely blank).