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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:33 AM.