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
[TABLE="width: 500"]
<tbody>[TR]
[TD]address[/TD]
[TD]street name[/TD]
[/TR]
[TR]
[TD]123 main st
[/TD]
[TD]=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C19,1,""),2,""),3,"")[/TD]
[/TR]
[TR]
[TD]1 home ave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12345 west ave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363 east st[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]address[/TD]
[TD]street name[/TD]
[/TR]
[TR]
[TD]123 main st
[/TD]
[TD]=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C19,1,""),2,""),3,"")[/TD]
[/TR]
[TR]
[TD]1 home ave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12345 west ave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363 east st[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]