Excel Search words from a cell and assign txt in another cell
Closed
kumarnc2003
TrowaD
- Posts
- 1
- Registration date
- Saturday March 2, 2013
- Status
- Member
- Last seen
- March 2, 2013
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Excel Search words from a cell and assign txt in another cell
- Excel search for word in cell ✓ - Forum - Word
- Excel search part of text in cell ✓ - Forum - Excel
- Excel search for multiple text strings in cell ✓ - Forum - Excel
- Excel function search for text in cell ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
1 reply
TrowaD
Mar 4, 2013 at 12:34 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Mar 4, 2013 at 12:34 PM
Kumanrc,
You could count the number of comma's:
=IF(ISERROR(SEARCH(",",B1)),"0%",IF(ISERROR(SEARCH(",",B1,SEARCH(",",B1)+1)),"10%","20%"))
Hopefully I was urgent enough.
Best regards,
Trowa
You could count the number of comma's:
=IF(ISERROR(SEARCH(",",B1)),"0%",IF(ISERROR(SEARCH(",",B1,SEARCH(",",B1)+1)),"10%","20%"))
Hopefully I was urgent enough.
Best regards,
Trowa