Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.
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)
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
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