steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I get a report that will have only one, or several numbers, in a cell like the attached example. I need to get only the first number in the next cell over. Not sure about how to do this without deleting them manually. But this report can be several hundred rows some times. . thanks for the help.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 123456789, 123456999, 987654321, 456789 | 123456789 | ||
2 | 456789, 123456, 123456789,987654 | |||
3 | 2653, 456789123, | |||
4 | 123456789 | |||
Sheet1 |