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

?????? ????????? ?????? ?????????
???? ???????: 303384 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ???? ?????? ?? "????? ??????" (??? ???? ??????? ???? ?????? ???????) ?? ???? ????? ??? ??????? ???? ???? ????? ????? ?????? ??????? ? ??? ??????? ?? ????? ??????. ???? ?? ???? Microsoft Excel ?? Mac ????? ???????? ??? ????? ?????? ???????? ?????.

??????? ????

???? ?????? ?????? ????? ????? ??? ???? ??? ????? ????? ?????? ??????? ? ??? ??????? ?? ????? ??????. ??????? ???? ?????? ?????? ?? ???? ???? ?? "??????? ??????".

??????

????? ??????? ??????? ?? ??????? ???????:
   A1:  Andrew P. Gray
   A2:  Tom Johnston
				
???? ????? ??????? ?? ??????? ???????:
   B1:  =SEARCH(" ",A1)
   C1:  =SEARCH(" ",A1,SEARCH(" ",A1)+1)
   D1:  =LEFT(A1,B1-1)
   E1:  =IF(ISERROR(C1)," ",MID(A1,B1+1,C1-B1))
   F1:  =IF(ISERROR(C1),RIGHT(A1,LEN(A1)-B1),RIGHT(A1,LEN(A1)-C1))
				
  • ???? ?????? ?? ?????? B1 ???? ??????? ?????? ?? ?????.
  • ????? ?????? ?? ?????? C1 ???? ??????? ??????? ?? ??? ?? ?? ???? ???? ?????. ???? # VALUE! ??? ?????.
  • ??? ??? ????? ????? ?? ?????? D1.
  • ?? ???? ???? "??????? ??????" (??? C1 ??? ???) ? ??? ??? ?? ?????? E1.
  • ??? ??? "??? ???????" ?? ?????? F1.
??? ??????? B1:F2 ?? ???? ??? ????? ????? ?? ??????? ?????. ????? D1:F2 ??????? ??? ???:

   D1: Andrew      E1: P.         F1: Gray
   D2: Tom         E2:            F2: Johnston
				
????? ??????? ??? ????? ?? ??? ??????? ????? ???? ?? ???????? ??? ?????? ??????? ?? ??????? ???????/????/????? ???????.

??? ????? ????????, ?? ????? ??? ????? ???? ????? ???????? ??????? ??????? ????????? ???. ?????? ????? ???? ??????? ???????:
  1. ??? ??????? D1:F2.
  2. ?? ??????? ????? ? ???? ??? ???.
  3. ?? ??????? ????? ? ???? ??? ??? ???.
  4. ???? ?????? ??? ?? ???? ??? ?????.
  5. ??? ??????? ?? A ??? C.
????? ???? ?????? ??????? ?? ????? ????? VBA ??? ??? ??????? ??? ????? ?????? ?????? ?? Visual Basic for Applications. ?? ???? ???? ??? ??????? ??? ????? ??????? ????? ???? ??? ????? ?? ??????? ??????. ??? ????? ?? ???? ??? ?? ?? ??? ????????? ?????? ?????? ???? ?????.

?????

?????? ??? ???? ?? ????????? ??? ???? ????? ???? ??? "????? Office" ? ???? ???? ???? ??? ?????, ???? ??? ??? ?? ???? ??? ????? ?????.

??????: ??? ??? ??????? ?????? ???? ??? ?? "????? Office" ??? ???? ??????? ?????.

???????

???? ???????: 303384 - ????? ??? ??????: 05/???? ??????/1435 - ??????: 2.2
????? ???
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X ?? Mac
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbnosurvey kbarchive kbmt kbinfo KB303384 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????303384

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