|
|
#5
07-13-2018, 01:15 AM
|
|||
|
|||
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 |
| excel basic find |
|
|
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 8 
Office 2016
Threaded Mode