flash fill 2 or more columns at same time

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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.

1000 main street1000main street
1 east blvd
99 south ave
800 grande street
333 north road

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,207
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top