lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I tried to use Flash Fill (ctrl + E) but did not work. Any idea how to use Flash fill to separate numbers from text in this case? Please see the table below. Thank you very much
I tried to use Flash Fill (ctrl + E) but did not work. Any idea how to use Flash fill to separate numbers from text in this case? Please see the table below. Thank you very much
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | abc123 | abc | 123 | ||
2 | 123abc | 123 | abc | ||
3 | 111aaaa | 1111 | aaaa | ||
4 | 222hhh888 | 222888 | hhh | ||
5 | hhh1hhh | ||||
6 | 1ddddd | ||||
7 | xyz123hello | ||||
8 | |||||
Sheet1 |