lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to get rid of all numbers in a text. So I thought of used nested substitute() function and nested 10 times go get ride of 0-9. I have a column with house address and i want to keep street address not the number and then autofill this function. Do you think there is better idea to do that? thanks
<tbody>
</tbody>
I want to get rid of all numbers in a text. So I thought of used nested substitute() function and nested 10 times go get ride of 0-9. I have a column with house address and i want to keep street address not the number and then autofill this function. Do you think there is better idea to do that? thanks
address | street name |
123 main st | =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C19,1,""),2,""),3,"") |
1 home ave | |
12345 west ave | |
363 east st | |
<tbody>
</tbody>