Formulas to search for certain words in cells
Solved/Closed
Juniore Guerra
-
Aug 20, 2010 at 12:15 AM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Formulas to search for certain words in cells
- Formula that searches in a row for a cell/column that contains ✓ - Forum - Excel
- Excel formula search for multiple text in cell ✓ - Forum - Excel
- Excel formula to search for text in a range of cells ✓ - Forum - Excel
- Excel formula for searching text in cell ✓ - Forum - Word
- Excel formula to search entire workbook ✓ - Forum - Excel
2 replies
venkat1926
Aug 20, 2010 at 06:15 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Aug 20, 2010 at 06:15 AM
SAMPLE DATA FROM A1 TI B11
HEADING 1 H2
AAAAAAAAAAAAAA 1
RETURNED ON AAA 2
SSSSSSSSSSSSSSS 3
DDDDDDDDDDDDDD 4
FFFFFFFFFFFFF 5
RETURNED ON BBB 6
GGGGGGGGGGGGGGG 7
HHHHHHHHHHHH 8
JJJJJJJJJJJJJJJJ 9
RETURNED ON CCCC 8
IN c2 copy this formula
=IF(LEFT(A2,11)="RETURNED ON",B2,"")
copy C2 down.
HEADING 1 H2
AAAAAAAAAAAAAA 1
RETURNED ON AAA 2
SSSSSSSSSSSSSSS 3
DDDDDDDDDDDDDD 4
FFFFFFFFFFFFF 5
RETURNED ON BBB 6
GGGGGGGGGGGGGGG 7
HHHHHHHHHHHH 8
JJJJJJJJJJJJJJJJ 9
RETURNED ON CCCC 8
IN c2 copy this formula
=IF(LEFT(A2,11)="RETURNED ON",B2,"")
copy C2 down.
venkat1926
Apr 2, 2011 at 09:49 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Apr 2, 2011 at 09:49 PM
1. Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
2. if those 250 characters are together on the left use the same formula changing 11 to 250. try this. I have never done this
2. if those 250 characters are together on the left use the same formula changing 11 to 250. try this. I have never done this
Aug 20, 2010 at 02:28 PM
Apr 2, 2011 at 05:35 PM