If the text is in cell A1, this function will work for one or two occurrences of a dash:
=MID(A1,IFERROR(FIND("- ",A1,FIND("- ",A1)+1),FIND("- ",A1))+2,LEN(A1))
Regards,
-Glenn
Text Char Char Count Formula
Error Checking - Formulas > Formula Auditing > Error Checking A 1 =target_count(B2,A2)
Error Checking - Formulas > Formula Auditing > Error Checking B 0 =target_count(B3,A3)
Error Checking - Formulas > Formula Auditing > Error Checking C 2 =target_count(B4,A4)
Error Checking - Formulas > Formula Auditing > Error Checking D 0 =target_count(B5,A5)
Error Checking - Formulas > Formula Auditing > Error Checking E 2 =target_count(B6,A6)
Error Checking - Formulas > Formula Auditing > Error Checking F 2 =target_count(B7,A7)
Error Checking - Formulas > Formula Auditing > Error Checking G 0 =target_count(B8,A8)
Error Checking - Formulas > Formula Auditing > Error Checking - 1 =target_count(B9,A9)
Error Checking - Formulas > Formula Auditing > Error Checking > 2 =target_count(B10,A10)
Error Checking - Formulas > Formula Auditing > Error Checking For 2 =target_count(B11,A11)
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Problem to With line | 4 | 41 | |
How to move the last 4 digits of a number to a new column | 8 | 43 | |
Excel - find text within text? | 1 | 24 | |
Applying Background Image to All Sheets in Excel | 1 | 16 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!