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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1000 main street[/TD]
[TD]1000[/TD]
[TD]main street[/TD]
[/TR]
[TR]
[TD]1 east blvd[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]99 south ave[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]800 grande street[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]333 north road[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1000 main street[/TD]
[TD]1000[/TD]
[TD]main street[/TD]
[/TR]
[TR]
[TD]1 east blvd[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]99 south ave[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]800 grande street[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]333 north road[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]