|
|
|
|
#1
07-12-2018, 11:55 PM
|
||||
|
||||
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 |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode