Extracting key words from a cell

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

FAQ

Thread Tools

Display Modes

07-12-2018, 11:55 PM

Pecoflyer

Windows 7 64bit Extracting key words from a cell

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Perhaps in C6: =IF(ISNUMBER(SEARCH("RHS",B6)),"RHS","LHS") and pull down as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

excel basic find

« Previous Thread | Next Thread »

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 09:22 PM.