Hlukanisa umugqa ube amakholomu ku-Excel

Lesi sibonelo sibonisa indlela yokuhlukanisa umugqa ube amakholomu amaningi ku-Excel.

Inkinga esibhekene nayo emfanekisweni ongenhla ukuthi sidinga ukutshela i-Excel ukuthi ihlukanise kuphi uchungechunge. Umugqa onombhalo othi “Smith, Mike” unokhefana endaweni yesi-6 (uhlamvu lwesithupha ukusuka kwesokunxele), futhi umugqa onombhalo othi “Williams, Janet” unokhefana endaweni yesi-9.

1. Ukuze ubonise kuphela igama kwelinye iseli, sebenzisa ifomula engezansi:

   =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)

   =ПРАВСИМВ(A2;ДЛСТР(A2)-НАЙТИ(",";A2)-1)

   Incazelo:

   • Ukuthola indawo yekhoma, sebenzisa umsebenzi THOLA (THOLA) - isikhundla 6.
   • Ukuze uthole ubude beyunithi yezinhlamvu, sebenzisa umsebenzi LEN (DLSTR) – izinhlamvu eziyi-11.
   • Ifomula ibilela ku: =KULUNGILE(A2-11-6).
   • Expression =KULUNGILE(A2) ikhipha izinhlamvu ezi-4 kwesokudla bese ikhipha umphumela oyifunayo - "Mike".
2. Ukuze ubonise kuphela isibongo kwelinye iseli, sebenzisa ifomula engezansi:

   =LEFT(A2,FIND(",",A2)-1)

   =ЛЕВСИМВ(A2;НАЙТИ(",";A2)-1)

   Incazelo:

   • Ukuthola indawo yekhoma, sebenzisa umsebenzi THOLA (THOLA) - isikhundla 6.
   • Ifomula ibilela ku: = KWESOKUNXELE(A2-6).
   • Expression = KWESOKUNXELE (A2) ikhipha izinhlamvu ezi-5 ukusuka kwesobunxele futhi inikeze umphumela oyifunayo - "Smith".
3. Gqamisa ububanzi B2:C2 bese uyihudulele phansi ukuze unamathisele ifomula kuwo wonke amaseli.