Thread: How do I reduce qwe.qwe.qwe in cell A1 to qwe in cell B1 ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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 ?

Reply With QuoteReply With Quote