allredkj
New member
I was hoping you could help me with the rest of my formula:
=MID(V2, FIND("BLK",V2)+4,3)
I'd like it to return (null) if there is not a match for "BLK". Also it's not taking into account, slashes and dashes:
BLK 78-1/2 LTS 1-8
PT LT 4 , TR 9 & ABND ROW
BLK 128/76 1/2 LTS 1-3, 8-10
BLK C/99 PT 1 63.5X100X62.3X100
BLK 3/6116 LT 9
BLK 4 LOT 12
Expected Output:
78
(null)
128
C
3
4
I thought about using a LEFT: =LEFT(V2, FIND("BLK",V2)+2) (but this finds and returns BLK and not sure how to complete this query)
Can you please advise me the efficient way of doing this? Thank you!!!
=MID(V2, FIND("BLK",V2)+4,3)
I'd like it to return (null) if there is not a match for "BLK". Also it's not taking into account, slashes and dashes:
BLK 78-1/2 LTS 1-8
PT LT 4 , TR 9 & ABND ROW
BLK 128/76 1/2 LTS 1-3, 8-10
BLK C/99 PT 1 63.5X100X62.3X100
BLK 3/6116 LT 9
BLK 4 LOT 12
Expected Output:
78
(null)
128
C
3
4
I thought about using a LEFT: =LEFT(V2, FIND("BLK",V2)+2) (but this finds and returns BLK and not sure how to complete this query)
Can you please advise me the efficient way of doing this? Thank you!!!