lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to change "street" to "st" and "road" to "rd". I wrote substitute() to change "street" to "st". I also want to change the "road" to "rd". My question, do I need to create another substitute() to change "road" to "rd"?
Can I change both of them using one function instead of doing them twice. Thank you very much.
I want to change "street" to "st" and "road" to "rd". I wrote substitute() to change "street" to "st". I also want to change the "road" to "rd". My question, do I need to create another substitute() to change "road" to "rd"?
Can I change both of them using one function instead of doing them twice. Thank you very much.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | address | new address | ||
2 | 100 main street | 100 main st | ||
3 | 20 east road | |||
4 | 88 west blv | |||
5 | 101 main street | |||
6 | 21 east road | |||
7 | 89 west blv | |||
8 | 102 main street | |||
9 | 22 east road | |||
10 | 90 west blv | |||
11 | 103 main street | |||
12 | 23 east road | |||
13 | 91 west blv | |||
14 | 104 main street | |||
15 | 24 east road | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =SUBSTITUTE(A2,"street","st") |