Excel formuls
Closed
Jay
-
4 Jun 2010 à 12:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Jun 2010 à 14:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Jun 2010 à 14:10
Related:
- Excel formuls
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel clear formatting - Guide
- Arrow keys not working in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
4 Jun 2010 à 14:10
4 Jun 2010 à 14:10
Yes
use 10 substitute
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,9,""),8,""),7,""),6,""),5,""),4,""),3,""),2,""),1,""),0,"")
use 10 substitute
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,9,""),8,""),7,""),6,""),5,""),4,""),3,""),2,""),1,""),0,"")
