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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I reduce qwe.qwe.qwe in cell A1 to qwe in cell B1 ? (https://www.excelbanter.com/excel-discussion-misc-queries/190189-how-do-i-reduce-qwe-qwe-qwe-cell-a1-qwe-cell-b1.html)

AR261070

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

I need the formula to reduce :

qwe.qwe.qwe in cell A1 on Excel

to :

qwe in cell B1 on Excel

Can anyone help ?

Don Guillett

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AR261070" wrote in message
...
I need the formula to reduce :

qwe.qwe.qwe in cell A1 on Excel

to :

qwe in cell B1 on Excel

Can anyone help ?

All times are GMT +1. The time now is 11:50 AM.