Jaco Swart
New Member
- Joined
- Jul 15, 2016
- Messages
- 8
Hi,
Is there is a formula that can look at a cell containing a lot of information and isolate just the numerical portion of the text. Unfortunately the text in all the cells is not consistent so I can’t just do a text to columns exercise.
For example if cell A1 may contain > contact: Piet email: piet@piet.com bank: XYZ Bank account number: 12345678 Address: 1 blue road, bellville, 7560.
I need to isolate just the account number (highlighted above) in example cell A2.
Hopefully there is a way to do this.
Is there is a formula that can look at a cell containing a lot of information and isolate just the numerical portion of the text. Unfortunately the text in all the cells is not consistent so I can’t just do a text to columns exercise.
For example if cell A1 may contain > contact: Piet email: piet@piet.com bank: XYZ Bank account number: 12345678 Address: 1 blue road, bellville, 7560.
I need to isolate just the account number (highlighted above) in example cell A2.
Hopefully there is a way to do this.