I have text in Col J and have a formula to extract the text before the first space
If the formula returns "BR1", I want the formula amended to extract the data to the left before the last space on the right
i have manually extracted the data in Col L
It would be appreciated if someone could kindly amend my formula
If the formula returns "BR1", I want the formula amended to extract the data to the left before the last space on the right
i have manually extracted the data in Col L
extract texct based on Name.xlsx | |||||
---|---|---|---|---|---|
J | K | L | |||
1 | BR1 South 985217 | BR1 | BR1 South | ||
2 | BR1 East 985218 | BR1 | BR1 East | ||
3 | BT2 HO 987258 | BT2 | BT2 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K1:K3 | K1 | =IF(LEFT(J1,FIND(" ",J1))="BR1",LEFT(J1,9),(LEFT(J1,FIND(" ",J1)))) |
It would be appreciated if someone could kindly amend my formula