MSExcel: Yaya za a sami matsayin halayyar a cikin kirtani?

Excel neman matsayin hali a zaren

Neman matsayin hali a cikin kirtani na iya zama aiki mai sauqi a cikin MSExcel, ta amfani da aikin ginanniyar ayyukan FIND.

Excel sami matsayin hali a cikin kirtani da cire kayan juyawa

Misali, bari muce muna da jerin kundin adireshi da sunayen fayiloli, kuma kawai muna son samun sakamako na karshe tare da sunayen fayil.

A wannan yanayin, har ma da  ci gaban gani a cikin Excel   ba zai taimaka ba, saboda ba zai ba da damar cire wani bayani daga babban hanyar ba.

Mafi kyawun mafita shine amfani da aikin “FIND” don nemo matsayin halayyar a cikin kirtani, kuma yi amfani da wannan lambar don cire ragowar kirtani ta amfani da aikin MID a cikin Excel.

Nemi matsayin hali a cikin kirtani mai kyau

Don nemo matsayin takamaiman halayyar da aka ba ta a cikin Excel, kawai a yi amfani da FIND a kan kirtani, a matsayin sigogi na halayyar da za a nemo da kuma igiyar da za a nemo, misali a cikin wata sel a cikin falle tayo. .

'=FIND("char",”string”)

Cire kirtani fara daga hali

Bayan haka, ta amfani da bayanin matsayin halayyar, yi amfani da aikin MID don cire maɓallin da ake buƙata farawa daga halayyar da aka samo ta ƙara +1, da kuma cire sauran ragowar kirtani ta amfani da madaidaicin madaidaicin silsila, kamar 999, zuwa Tabbatar an rufe dukkan sakamakon.

'=MID(“string”,”char”+1,999)

Excel cire rubutu kafin hali

Don cire rubutun kafin abin da aka bayar a cikin Excel, kawai sami matsayin halayyar, kuma yi amfani da aikin “LEFT” tare da haruffa ɗaya ƙasa don cire rubutun kafin halin da aka samo.

'=LEFT(“string”,”char”-1)

Nemo abin da ya faru na halayyar sa a cikin kirtani mai kyau

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

Neman yanayin kasancewarsa a cikin sigar fasaha a cikin Excel wanda aka yi shi ta amfani da duka ayyukan KYAUTA da KYAUTATA.

Aikin “KYAUTATA” zai maye gurbin misalin da aka nema na halayen bincike na musamman ta hanyar binciken, kuma aikin FIND zai sami matsayin wannan halayyar ta musamman a zaren.

Kawai zabar abin da ya faru na nth don dubawa a cikin zaren da aka bayar, kuma za a nuna sakamakon da ke nuna yanayin halayen nth a cikin kirtani.

'=FIND(CHAR(1),SUBSTITUTE(“string”,”char”,CHAR(1),nth))

Excel neman matsayin hali a zaren from right

Don neman matsayin halayyar a cikin kirtani daga hannun dama, za mu yi amfani da solutioj iri ɗaya ta amfani da FIND da KYAUTATA don nemo abin da ya faru na ƙarshe na halin da aka bayar a cikin zaren.

Tare da wannan maganin, za a nuna matsayi na ƙarshe na hali a cikin kirtani, wanda kuma shine matsayin hali a cikin kirtani daga dama, za a nuna.

'=FIND(CHAR(1),SUBSTITUTE(“string”,”char”,CHAR(1),LEN(A2)-LEN(SUBSTITUTE(“string”,”char”,""))),1)

Tambayoyi Akai-Akai

Wane irin tsari za a iya amfani da shi a cikin fice don gano matsayin takamaiman halaye a cikin igiyar rubutu, yana taimakawa a cikin bayanan bayanai?

Yi amfani da 'sami' ko aikin bincike na 'Bincika don nemo matsayin halayyar halayyar mutum a cikin kirtani. Tsarin yana kama da '= nemo (Halin Sauya 'haruffa tare da halin da kuke nema da kuma' tantanin halitta` tare da tantanin halitta.

Cikakken 2019 Excel ga Masu farawa a bidiyo