sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to find a way I can extract the string from cell values.
Each cell will have a unique number which will always begin with 'N' followed by a series of numbers, which can be any number though not likely to be more than 6. After that there is a surname, followed by first name(s) and then a gender.
Here are a couple of examples;
or
If it's possible, and I appreciate it may be a big ask, I need the strings extracted so that I end up with 3 columns showing 'N' number, name and then gender.
Can anyone assist?
Each cell will have a unique number which will always begin with 'N' followed by a series of numbers, which can be any number though not likely to be more than 6. After that there is a surname, followed by first name(s) and then a gender.
Here are a couple of examples;
N342 STORNCH ANNE FEMALE
or
N76 STEVENS JOHN GEORGE UNKNOWN
If it's possible, and I appreciate it may be a big ask, I need the strings extracted so that I end up with 3 columns showing 'N' number, name and then gender.
Can anyone assist?