TheTallBloke
New Member
- Joined
- Sep 3, 2015
- Messages
- 30
Hello folks,
Bit of a strange one - I am working on correcting data inconsistencies in model numbers sent by an incorigible supplier.
The goal is finding the following string within a cell and appending the letter X at the end:
(letter)(4 consecutive numbers)(letter in defined list - [E,V]) -> should get the letter X appended
I would like to do this using a formula rather than a macro - for control/ease of use reasons.
Example attached - apologies for using dummy data, confidentiality is the reason.
<tbody>
</tbody>
Possible or impossible? Thanks.
Bit of a strange one - I am working on correcting data inconsistencies in model numbers sent by an incorigible supplier.
The goal is finding the following string within a cell and appending the letter X at the end:
(letter)(4 consecutive numbers)(letter in defined list - [E,V]) -> should get the letter X appended
I would like to do this using a formula rather than a macro - for control/ease of use reasons.
Example attached - apologies for using dummy data, confidentiality is the reason.
ABC-DEF1234EX 1.2.3.4 | correct |
ABC-DEF1234E 5.2.3.4 | should be ABC-DEF1234EX 1.2.3.4 |
DGH4321V 1.2.3-4 | should be DGH4321VX 1.2.3-4 |
ABCDD-1114X | should be ignored |
<tbody>
</tbody>
Possible or impossible? Thanks.