analyst0503
New Member
- Joined
- Aug 5, 2021
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hello,
I have a very specific example where I want to only extract numbers between specific characters and I can't find a formula to do this in bulk. Would be grateful for any help!
As you can see in the example above, I only want to keep a specific number. These are dates that will be 4 digits and therefore I would like to only extract those. They are separated by a pipe symbol. The pattern is always 4 digits between pipe symbols.
Thanks in advance!
I have a very specific example where I want to only extract numbers between specific characters and I can't find a formula to do this in bulk. Would be grateful for any help!
As you can see in the example above, I only want to keep a specific number. These are dates that will be 4 digits and therefore I would like to only extract those. They are separated by a pipe symbol. The pattern is always 4 digits between pipe symbols.
Thanks in advance!