jellevansoelen
New Member
- Joined
- Mar 1, 2021
- Messages
- 29
- Office Version
- 365
- 2019
- Platform
- Windows
Hi Excel expert,
I have a excel document with more than 20.000 rows with the following data:
It's start with two letters followed by a year followed by a few numbers, like this:
I'm looking for a formule or script what extract the year and copy that to a other cell?
Can someone help me?
Tnx
I have a excel document with more than 20.000 rows with the following data:
| Book1 | |||
|---|---|---|---|
| A | |||
| 1 | BL1934003 | ||
| 2 | BL1934004 | ||
| 3 | BL1934005 | ||
| 4 | BL1934006 | ||
| 5 | PP2010084 | ||
| 6 | PP2010085 | ||
| 7 | PP2010086 | ||
| 8 | RB2003001 | ||
| 9 | RB2003002 | ||
| 10 | RB2003003 | ||
Sheet1 | |||
It's start with two letters followed by a year followed by a few numbers, like this:
| Book1 | |||||
|---|---|---|---|---|---|
| D | E | F | |||
| 8 | BL1934004 | ||||
| 9 | BL | 1934 | 004 | ||
| 10 | 2 letters | year | numbers | ||
Sheet1 | |||||
I'm looking for a formule or script what extract the year and copy that to a other cell?
Can someone help me?
Tnx
