Extracting key words from a cell

		Microsoft Office Forums > Microsoft Excel > Excel
Extracting key words from a cell

07-13-2018, 01:15 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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",""))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for extracting data from multiple sheets if cell has text	plasma33	Excel Programming	0	11-10-2016 12:52 AM
Extracting multiple words from one cell into individual rows while copying all other data	randyaserve	Excel Programming	4	10-05-2015 09:52 AM
Extracting data from a cell with multiple lines of text	MMT	Excel	9	02-12-2015 09:18 PM
Excel 2013 – need help extracting date and time from text cell plus more.	Art Mann	Excel	1	07-18-2014 09:55 PM
Extracting Cell color	bsaucer	Excel	1	06-19-2009 06:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.