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
- How to search for words on a page - Guide
- If a cell has text then return value ✓ - Excel Forum
- Ping to txt - Guide
- Search from google usa - Guide
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