Excel Search words from a cell and assign txt in another cell
Closed
kumarnc2003
Posts
1
Registration date
Saturday March 2, 2013
Status
Member
Last seen
March 2, 2013
-
Mar 2, 2013 at 12:56 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 4, 2013 at 12:34 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 4, 2013 at 12:34 PM
Related:
- Excel Search words from a cell and assign txt in another cell
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Www.google.com search video - Download - Video playback
- Highlight cell if another cell contains text ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Mar 4, 2013 at 12:34 PM
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