Tusitusiga Tusitusiga
Afai e te tu'uina se numera i totonu o se sela (fa'asologa fa'asologa), o le a fa'aalia e peiSaienisi, ae manaʻomia le faʻaalia o se numera.Ona, vaevae lea o numera i koluma A ma B, ma tuʻufaʻatasia i le koluma C, lea "=A1&B1
".
Ou te manaʻo e teu le koluma C ma tape le koluma A ma le B, ae afai ou te tapeina le koluma A poʻo le B faʻafuaseʻi, o le a mou atu faʻamatalaga o le koluma C, o le a le mea e tatau ona ou faia?
E faʻafefea ona tuʻufaʻatasia ni koluma se lua i le laulau e tasi i Excel?
Muamua, se'i o tatou va'ai pe fa'afefea ona tu'ufa'atasia e le EXCEL fa'amaumauga,E mafai ona e ausia le tuufaatasia e ala i le tuufaatasia o galuega & ▼
Kopi ma faapipii i latou e fai ma "taua"▼
- Ona tape lea o sela aʻo leʻi tuʻufaʻatasia.
O fa'amatalaga laulau a le komepiuta EXCEL e vave tape ese sela tu'ufa'atasia
A uma ona tuʻufaʻatasia i le EXCEL, tape le sela aʻo leʻi tuʻufaʻatasia, ae o le a taofia faʻamaumauga tuʻufaʻatasia.
O laasaga fa'atino fa'apitoa o lenei metotia e fa'apea:
1. Tatala le laulau EXCEL e fa'agaioia i luga o le komepiuta ma fa'aoga le galuega tu'ufa'atasi i le sela avanoa=B4&C4
, ona oomi lea o le Enter e fa'auma ai le fa'atonuga o galuega ma fa'aoga ▼
- Tusi i totonu se sela avanoa
=
- A uma ona kiliki le sela muamua e te manaʻo e tuʻufaʻatasia, ulufale
&
- A uma ona kiliki le cell lona lua e te manaʻo e tuʻufaʻatasia, kiliki
Enter
ulufale - Faatumu sela pito i lalo ua tu'u fa'atasi i lalo
- (i
B4
maC4
Mo sela e tuʻufaʻatasia, e mafai ona suia e tusa ai ma le tulaga moni)
2. Ona oomi lea o le Ctrl+C e kopi ai le sela i'uga tu'ufa'atasi▼
3. Kiliki taumatau i luga o se potu avanoa ma filifili "Paste as Value" i le "Paste Special" ▼
- Aveese sela aʻo leʻi tuʻufaʻatasia, ma iloa o sela aʻo leʻi tuʻufaʻatasia e tapeina pe a maeʻa ona tuʻufaʻatasia le laulau EXCEL, ma faʻamaeʻa le gaioiga o le taofia o faʻamaumauga tuʻufaʻatasia.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) faasoa "E faʻafefea ona tuʻufaʻatasia ma tape koluma i le komepiuta EXCEL?Faʻamatalaga Faʻamatalaga Faʻataʻitaʻi Faʻaumatia Cells Merged", o le a fesoasoani ia te oe.
Fa'afeiloa'i e fa'asoa le so'otaga o lenei tusitusiga:https://www.chenweiliang.com/cwl-29147.html
Faʻafeiloaʻi i le Telegram channel o le blog a Chen Weiliang e maua ai faʻamatalaga lata mai!
📚 O lenei taʻiala o loʻo i ai le taua tele, 🌟O se avanoa e seasea maua, aua le misia! ⏰⌛💨
Faasoa ma fiafia pe a e fiafia i ai!
O lau fefa'asoaa'i ma le fiafia o la matou fa'aosofiaga faifaipea!