How do I extract text between two instances of a character?
- 1 Answers
- 929 Views
- I also Faced
- E-Mail Answers
Answer / Asha Rani
In MS Excel, you can use the MID and FIND functions to extract text between two instances of a character. For example: =MID(A1, FIND("a", A1, FIND("b", A1) - 1) + 1, FIND("c", A1) - FIND("a", A1, FIND("b", A1) - 1) - 1). This formula will return the text between 'a' and 'c', excluding both characters.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I calculate tax in excel?
How can an individual use spreadsheets?
What is the difference between counta and count in excel?
What is ribbon?
How do you click f4 in excel?
How long does it take to learn vlookup?
What is difference between ms excel and ms word?
What is ms excel spreadsheet?
Can you do an if contains in excel?
What are pivot tables used for?
Can you have two formulas in one cell excel?
Can you conditional format a cell based on another cell?
MS Excel Microsoft 
