How do I reduce qwe.qwe.qwe in cell A1 to qwe in cell B1 ?

A

AR261070

I need the formula to reduce :

qwe.qwe.qwe in cell A1 on Excel

to :

qwe in cell B1 on Excel

Can anyone help ?
 
D

Don Guillett

If always separated by a dot (period)
=IF(ISERR(FIND(".",A1)),"",LEFT(A1,FIND(".",A1)-1))
 
Top