????? ???? ??? ???? ????? ???? ?? ?????? ?? ??????? ?? Excel ?? Mac

?????? ????????? ?????? ?????????
???? ???????: 187667 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ??????? ??? ????? ????? ???????:
  • ??? ????????? ?????? ???? ?? ???? ?? ???????.
  • ??? ???? ????? ??? ?? ???? ?????.
  • ??? ???? ????? ??? ?? ???? ?? ???????.
  • ??? ??????? (?? ????? ????) ?????? ???? ?? ????.

??????? ????

???? ????? ??? ????????? ?????? ???? ?? ????

?????? ?????? ??????? ????? ??? ????????? ?????? ???? ?? ????:
=SUM(LEN(<range>)-LEN(SUBSTITUTE(<range>,"text","")))/LEN("text")
??? <range>?? ???? ??????? ??????? "?"????"??? ??????? ????? ?? ???? ???? ???? ?????.

?????? ??? ????? ?????? ????? ????? ????. ????? ???? ????? ????, ???? ??? COMMAND + RETURN.

??? ?? ??? ?????? ?????? ?????? ??? ??????? ?????? ????? ????? ??? ???? ?? ?????? ?????? ?????? ??? ????? ??????? ??????. ???? ??????? ??? ?????? ??? ???? ????? ???? ?? ??? ?????? ?? ??? ?????? ????? ??? ??????? ?? ????.

???? 1: ?? ??? ????????? ?????? ???? ?? ????

  1. ????? Microsoft Excel ???? ???? ????.
  2. ???? ?? ??? ??? sheet1:
          A1: Fruit
          A2: apple,apple
          A3: orange
          A4: apple,orange
          A5: grape
          A6: orange,grape
          A7: grape, apple
          A8: =SUM(LEN(A2:A7)-LEN(SUBSTITUTE(A2:A7,"apple","")))/LEN("apple")
    						
    ??????: ??? ?? ??? ????? ?????? ????? ????? ????. ????? ???? ????? ????, ???? ??? COMMAND + RETURN.
???? ?????? A8 ???? 4 ???? ?? "??????" ???? ???? ?? ??????.

???? ????? ??? ????????? ??? ???? ?? ???? ?????

??? ??? ????? ??? ????? ?? ??? ???? ?? ???? ????? ??? ????? ?????? ???:
=LEN(<range>)-LEN(SUBSTITUTE(<range>,"a",""))
??? <range>?? ???? ??????? ??????? "?"a"??? ??????? ?????? ???? ???? ?????.

??????: ?? ????? ??? ?????? ??????? ????? ????.

???? 2: ?? ??? ????????? ??? ?? ???? ?????

??????? ??? ???????? ?? ?????? ??????; ????? ???? ???? ??? ???? ?????? ?? ????? "p" ?? A7. ???? ?????? ??????? ?? ?????? A9:
A9: =LEN(A7)-LEN(SUBSTITUTE(A7,"p",""))
?? ???? ?????? A9 3 ??? ????? "p" ???? ???? ???? ?? A7.

???? ????? ??? ????????? ??? ???? ?? ????

??? ??? ????? ??? ????? ?? ??? ???? ?? ???? ?? ????? ?????? ???:
=SUM(LEN(range)-LEN(SUBSTITUTE(range,"a","")))
??? <range>?? ???? ??????? ??????? "?"a"??? ??????? ?????? ???? ???? ?????.

?????? ??? ????? ?????? ????? ????? ????. ????? ???? ????? ????, ???? ??? COMMAND + RETURN.

???? 3: ?? ??? ????????? ????? ?? ????

??????? ??? ???????? ?? ?????? ??????; ????? ???? ???? ??? ???? ?????? ?? ????? "p" ?? A2:A7. ???? ?????? ??????? ?? ?????? A10:
A10: =SUM(LEN(A2:A7)-LEN(SUBSTITUTE(A2:A7,"p","")))
??????: ??? ?? ??? ????? ?????? ????? ????? ????. ????? ???? ????? ????, ???? ??? COMMAND + RETURN.

?? ???? ?????? A10 11 ??? ???? ????? "p" ???? ???? ??? ????? ?? A2:A7.

???? ????? ??? ??????? ?????? ???? ?? ????

?????? ??????? ????? ??? ??????? ?? ???? ???? ??? ????? ?????? ???? ?????:
= IF (LEN (TRIM (<cell_ref>)) = 0, 0, LEN (<cell_ref>)-LEN(SUBSTITUTE(<cell_ref>,<char>,""))+1)
??? <cell_ref> ?? ???? ?????? ? <char>?? ??? ??? ???????.

?????? ???? ?????? ?? ?????? ?????; ???? ?????? ?????? ??? ??????? ?????? ?? ??? ???????. ?? ??? ?????? ??? ?????? ??? ?????? ?? ??????. ?? ????? ??? ?????? ??????? ????? ????.

???? 4: ?? ??? ??????? ?????? ?????? ?? ????

???? ??????? ??????? ????? ??? ??????? ?? ???? ??? ??? ??? ??????? ?????? ??? ?????:
  1. ????? Microsoft Excel ???? ???? ????.
  2. ???? ?? ??? ??? sheet1:
         A1: The car drove fast
         A2: =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)
???? ?????? ?? ?????? A2 ???? 4 ???? ????? ??????? ??? ???? ????? ?????? ??????. ??? ???? ??????? ?????? ??????? ?????? ?? ??? ??????? ???? ?? ????? ?????? ?? ???. ???? ?????? TRIM ???????? ??????? ? ??????? ???????? ???? ????? ???? ?? ??????.

?? Microsoft Excel? ????? ????? ??????? ????? ????? ??? ????????? ???? ????? ?? ???? ?? ???? ?? ???????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
89794????? ??????? Visual Basic for Applications ???? ??? ???? ????? ?????? ?? ????? ?? Excel

???????

???? ???????: 187667 - ????? ??? ??????: 04/????/1428 - ??????: 3.3
????? ???
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X ?? Mac
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbhowto KB187667 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????187667

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com