rangequestion
Board Regular
- Joined
- Nov 21, 2016
- Messages
- 62
Hi,
I have a column of text fields and I'd like to extract the text in each cell based on 2 conditions. I need to extract the text that comes after the very first dahs (-) AND before the colon
). For example I have the following string:
MT202I-ACB: /BNF/
And I only want to extract "ACB". Note that the length of text that I want extracted can vary. It can be either 2, 3 or 4 characters long.
thanks!
I have a column of text fields and I'd like to extract the text in each cell based on 2 conditions. I need to extract the text that comes after the very first dahs (-) AND before the colon

MT202I-ACB: /BNF/
And I only want to extract "ACB". Note that the length of text that I want extracted can vary. It can be either 2, 3 or 4 characters long.
thanks!