Excel Search words from a cell and assign txt in another cell
Closed
kumarnc2003
Posts
1
Registration date
Saturday 2 March 2013
Status
Member
Last seen
2 March 2013
-
2 Mar 2013 à 12:56
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Mar 2013 à 12:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Mar 2013 à 12:34
Related:
- Excel Search words from a cell and assign txt in another cell
- Excel multiple lines in one cell - Guide
- Google search from usa - Guide
- Number to words in excel - Guide
- How to delete a cell in word - Guide
- How to copy data from one excel sheet to another - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
4 Mar 2013 à 12:34
4 Mar 2013 à 12:34
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
