lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to use Flash fill to separate street number from street name. I know how to do it column by column. For example I type 1000 in b1 and the Ctrl+E and that will Flash Fill all the column. I can do the same thing with column C. I type main street then Ctrl+E
My question can I fill both of them at same time? Thank you.
<tbody>
</tbody>
I want to use Flash fill to separate street number from street name. I know how to do it column by column. For example I type 1000 in b1 and the Ctrl+E and that will Flash Fill all the column. I can do the same thing with column C. I type main street then Ctrl+E
My question can I fill both of them at same time? Thank you.
| 1000 main street | 1000 | main street |
| 1 east blvd | ||
| 99 south ave | ||
| 800 grande street | ||
| 333 north road |
<tbody>
</tbody>
