Shaqada CONCATENATE ee xaashida Google^{(Google Sheets)} waxay ku biirtaa qaybo badan oo xog ah. Shaqadani waa mid waxtar leh marka la maareynayo xog badan oo mid kastaa u baahan yahay daaweyn la mid ah.

Tusaale ahaan, waxaad isticmaali kartaa shaqada CONCATENATE haddii xaashidu leedahay hal tiir oo magac hore ah iyo mid kale oo magac dambe ah, laakiin aad rabto in la isku daro si ay u sameeyaan hal unug oo leh labada magac. Waxaad tan gacanta ku qori kartaa magac kasta, ama waxaad isticmaali kartaa CONCATENATE si aad otomaatig ugu samayso.

Tusaalayaal badan oo kale oo ku saabsan shaqada CONCATENATE ayaa la bixin karaa, marka waxaan eegi doonaa dhowr hoos.

Tusaale Fudud

Qaabka ugu fudud, CONCATENATE waxay u shaqaysaa laba qaybood oo xog ah iyada oo aan wax ikhtiyaar ah lahayn. Taasi waxay suurtogal ku tahay qaabkan fudud:

=CONCATENATE(A1,B1)

Dabcan, tusaalahan, waxaan u qaadaneynaa in magaca koowaad uu ku jiro unugga A1 iyo kan labaad ee unugga B1. Waxaad tan ku waafajin kartaa xaashida xisaabaadkaaga adiga oo tixraacyadaas ku beddelaya kuwaaga.

Marka la riixo Gelida ^(MaryTruman)tusaalahan^(Enter) gaarka ah waxay soo saari doontaa MaryTruman . Sida aad arki karto, magaca hore waxa uu ka soo horjeedaa magaca dambe. Shaqada CONCATENATE waxay shaqadeeda ku qabsatay muuqaalkan, laakiin waxaa jira doorashooyin kale oo aad ku dari karto si aad u ballaariso awoodeeda, sida inaad ku darto meel bannaan ama xogta unugyada kale.

Isticmaalka meel bannaan oo ku jirta Formula CONCATENATE^{(CONCATENATE Formula)}

Ogaanshaha sida meelaha bannaan loogu isticmaalo CONCATENATE waa muhiim sababtoo ah kaydinta xogta inta badan looma dejiyo sida saxda ah ee aad rabto inay noqdaan. Sida tusaalaheena sare, waxaan rabnaa in magaca uu u ekaado mid la arki karo anagoo ku darayna meel bannaan oo u dhexeysa labada unug.

Meelo banaan ayaa lagu soo daray shaqada Google Sheets iyadoo la isticmaalayo xigashooyin laba jibaaran:

=CONCATENATE(A1,” ”,B1)

Haddii aadan halkan arki karin, waxaa jira meel bannaan oo xigashooyinkaas ah. Fikradda ka dambeysa isticmaalka xigashooyinka ayaa ah in aad xogta u geleyso gacanta oo aadan dooran xogta xaashida.

Si kale haddii loo dhigo, A1 iyo B1 waxay si cad uga mid yihiin xaashida xaashida, markaa waxaad tixraacaysaa iyaga oo u galaya sida ay yihiin (xaraf unug iyo lambarka gacanta). Si kastaba ha ahaatee, si aad xogtaada ugu darto qaacidada, waxaad u baahan tahay inaad ku xeeriso xigashooyin.

Ku darida qoraalka^(Text) foomka CONCATENATE^{(CONCATENATE Formula)}

Shaqada CONCATENATE waxa ay qaban kartaa in ka badan in ay ku biirto unugyada lamaanaha oo ay meel bannaan dhex dhigto. Hoos^(Below) waxaa ku yaal tusaale sida loo isticmaalo CONCATENATE si loo sameeyo jumlad dhan iyadoo la isticmaalayo xogta unugga.

Tusaalahan hawsha CONCATENATE , waxa aanu isku xidhaynaa degmada iyo nambarkiisa darajada,laakin halkii aan kaga tageyn lahayn,waxa aanu isticmaaleynaa meelo banaan iyo xogtayada gacanta lagu galiyey si aan u abuurno jumlad buuxda:

=CONCATENATE(A2, " is", " ranked ", C2, " compared to these other ceremonial counties.")

Si aad qaacidadu ugu shaqeyso sida Ingiriisiga^(English) caadiga ah , ha ilaawin inaad meel dhigto meelaha loo baahdo. Ma ku dari kartid boos isla markaaba tixraaca unugga (sida C2 ee kore), laakiin waad awoodaa markaad isticmaalayso xigashooyin laba jibaaran. Sida aad kor ku arki karto, waxaan u isticmaalnay meel bannaan dhowr jeer oraahyadayada si jumlada si caadi ah loogu akhriyo.

Dalbashada foomka CONCATENATE meel kale^{(CONCATENATE Formula Elsewhere)}

Ugu dambeyntiina, isticmaalka dhabta ah ee kaliya ee shaqada CONCATENATE waa marka la macaamilayo xog ku filan in waqtiga la keydiyo oo la galo xogta gacanta. Markaa, waxa kaliya ee aad u baahan tahay inaad samayso si aad caanaha ula shaqeyso unugyada kale waa inaad hoos u jiidataa.

Guji^(Click) unugga hal mar si uu u iftiimiyo. Waa inaad ku aragtaa sanduuq yar oo ku yaal geeska midig ee hoose ee unugga, sida tan:

Guji^(Click) oo hay sanduuqa intaad hoos u jiidayso si aad ugu dabaqdo kaydka xogta. Jooji^(Stop) jiidashada marka aad gaarto shayga ugu dambeeya ee aad rabto in caanaha lagu dabaqo. Mar walba waad ka soo jiidi kartaa meesha haddii aad u baahato inaad unugyo badan ku darto hadhow.

Waxa xiiso leh, Google Sheets waxay leedahay shaqo la mid ah oo loo yaqaan SPLIT . Si kastaba ha ahaatee, halkii aad ku biiri lahayd unugyada, waxay u kala qaybisaa hal unug unugyo badan iyadoo ku xiran hadba dabeecadda aad doorato inaad calaamadiso barta kala-baxa.

How to Use the CONCATENATE Function in Google Sheets

The CONCATENATE function in Google Sheets joins together multiple chunks of dаta. Τhis function is helрful when managing large sets of information that each need a sіmilar treatment.

For example, you might use the CONCATENATE function if the spreadsheet has one column for a first name and another for a last name, but you want them joined together to form a single cell with both names. You could this manually by typing each name, or you can use CONCATENATE to automate it.

Many other examples of the CONCATENATE function could be given, so we’ll look at a few below.

A Simple Example

At its simplest form, the CONCATENATE function pieces together two sets of data without any other options. That’s possible with this simple form:

=CONCATENATE(A1,B1)

Of course, in this example, we’re assuming the first name is in cell A1 and the second in cell B1. You can adapt this to your own spreadsheet by replacing those references with your own.

Pressing Enter with this particular example would produce MaryTruman. As you can see, the first name is butted right up against the last name. The CONCATENATE function did its job in this scenario, but there are other options you can include in it to expand its capabilities, like to add a space or data from other cells.

Using a Space in the CONCATENATE Formula

Knowing how to use spaces with CONCATENATE is important because datasets often aren’t set up exactly how you want them to be. Like in our example above, we want the name to look presentable by adding a space between the two cells.

Spaces are included in this Google Sheets function using double quotes:

=CONCATENATE(A1,” ”,B1)

If you can’t see here, there’s a space within those quotes. The idea behind using the quotes is that you’re entering data manually and not choosing spreadsheet data.

In other words, A1 and B1 are clearly part of the spreadsheet already, so you’re referencing them by entering them as they are (the cell letter plus the cell number). However, to include your own data within the formula, you need to surround it in quotes.

Adding Text to a CONCATENATE Formula

The CONCATENATE function can do more than just join a couple cells and put a space between them. Below is an example of how to use CONCATENATE to form an entire sentence using cell data.

In this example of the CONCATENATE function, we’re stringing together the county and its rank number, but instead of leaving it at that, we’re using spaces and our own manually-entered data to create a full sentence:

=CONCATENATE(A2, " is", " ranked ", C2, " compared to these other ceremonial counties.")

To make the formula work like regular English, don’t forget to put spaces where necessary. You can’t add a space right after a cell reference (like C2 above), but you can when using double quotes. As you can see above, we used a space multiple times in our quotes to make the sentence read normally.

Applying the CONCATENATE Formula Elsewhere

Lastly, the only real use of the CONCATENATE function is when dealing with enough data that time is being saved versus entering the data manually. So, all you need to do to make the formula work with the other cells is drag it downward.

Click the cell once so that it’s highlighted. You should see a small box on the bottom right-hand corner of the cell, like this:

Click and hold that box while dragging it downward to apply it to the dataset. Stop dragging once you’ve reached the last item you want the formula to be applied to. You can always drag it again from there should you need to include more cells later.

Interestingly, Google Sheets has a similar function called SPLIT. However, instead of joining the cells, it splits one cell into multiple cells depending on which character you choose to mark as the split-off point.

Related posts

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato

• U samee qoraha OpenOffice muuqaal oo u shaqeeyo si ka badan sida Microsoft Word

• Sida Looga Saaro Xudduudaha Shaxda Google Docs

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida Google Docs Chat uu kuugu caawiyo inaad ka wada-shaqayso dukumentiyada

• Google Slides vs Microsoft PowerPoint - Waa maxay faraqa u dhexeeya?

• Sida Loo nadiifiyo Muuqaalka Cache

• Sida loo qaado oo loo geliyo Screenshots addoo isticmaalaya OneNote

• Hagaaji MS Office "Ma Xaqiijin Karo Shatiga" Fariinta Khaladka

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Google Docs vs Microsoft Word - Waa maxay faraqa u dhexeeya?

• 9 Siyaabood Oo Loo Furo Dukumeenti Kalmadeed La'aanteed

• Hagaaji Dhamaadka Tag Start Tag Isbarbar-dhigga Ciladda Marka la furayo faylalka DOCX

• Sida loogu daro Qoraallada Footnotes ee Word

• Sida loo abuuro oo loo socodsiiyo Macro gudaha Word

• Waa maxay Microsoft 365?

• Sida looga Dhoofiyo Iimaylkaaga Microsoft Outlook una dhoofin lahayd CSV ama PST

• Sida loo Beddelayo Cabbirka Islaaydhka ee PowerPoint si loo soo bandhigo Wanaagsan

• Sida loo hagaajiyo Bookmark aan lagu qeexin qalad gudaha Word

• Geli Xabad dhexda Weedha Erayga