NiksTroubles
New Member
- Joined
- Aug 29, 2023
- Messages
- 2
- Office Version
- 365
I am trying to extract content from a cell that contains text as followed (text between the brackets):
"Yes - configurable
Some text on that is not important"
I am able to strip the "Yes - " using: =RIGHT(A1;LEN(A1)-(FIND("-";A1)))
and
I am able to extra the word before the return using: =LEFT(A1;FIND(CHAR(10);A1)-1)
How can I combine the two formulas to only receive the value "configurable"?
Note that the first paragraph of a cell differs per row: "yes - available"; "no - not available", etc
"Yes - configurable
Some text on that is not important"
I am able to strip the "Yes - " using: =RIGHT(A1;LEN(A1)-(FIND("-";A1)))
and
I am able to extra the word before the return using: =LEFT(A1;FIND(CHAR(10);A1)-1)
How can I combine the two formulas to only receive the value "configurable"?
Note that the first paragraph of a cell differs per row: "yes - available"; "no - not available", etc