Thread: Extracting key words from a cell
View Single Post
 
Old 07-13-2018, 01:15 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
For C6, the one possible working formula will be
Code:
=IF(LEN(SUBSTITUTE(B6,"RHS",""))<LEN(B6),"RHS",IF(LEN(SUBSTITUTE(B6,"LHS",""))<LEN(B6),"LHS",""))
Reply With Quote