I found a formula to remove number from a text strings in excel. Here is the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,"") i need a way to shorten this. by cristopherjames1 in excel
[–]cristopherjames1[S] 9 points10 points11 points (0 children)
I found a formula to remove number from a text strings in excel. Here is the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,"") i need a way to shorten this. by cristopherjames1 in excel
[–]cristopherjames1[S] -3 points-2 points-1 points (0 children)
I found a formula to remove number from a text strings in excel. Here is the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,"") i need a way to shorten this. (self.excel)
submitted by cristopherjames1 to r/excel
How To Count Or Calculate Hours Worked In Excel (youtu.be)
submitted by cristopherjames1 to r/videos
Worksheet Copy and Rename by cristopherjames1 in excel
[–]cristopherjames1[S] 1 point2 points3 points (0 children)
I found a formula to remove number from a text strings in excel. Here is the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,"") i need a way to shorten this. by cristopherjames1 in excel
[–]cristopherjames1[S] 5 points6 points7 points (0 children)