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 December 27, 2022 - Mar 4, 2013 at 12:34 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 4, 2013 at 12:34 PM
Related:
- Excel Search words from a cell and assign txt in another cell
- Number to words in excel - Guide
- Www.google.com search video - Download - Video playback
- How to search words on a page - Guide
- Excel formula to subtract one cell from another - Excel Forum
- Messenger search in conversation not working - Facebook Messenger Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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