Judul : How to Combine Two Cell in Excel [ Version English ]
link : How to Combine Two Cell in Excel [ Version English ]
How to Combine Two Cell in Excel [ Version English ]
How to Combine Two Cell Data
Into Single Cell Excel
With Microsoft Excel
In Microsoft Excel not possibly, things that are not, such as combining the two in a single Cell Cell sentence into a sentence, it certainly is very usefull thing for those who like that split apart the data file.
In making the data to Excel tekadang we need to incorporate in data from multiple Cell into one particular Cell. To combine multiple cells that contain data in Excel, there are two carra, following his ways.
1. Combine Data with operators '&'
To combine data from multiple Excel cells in either the formula or text character (string) can add operator '&' sample application in Excel can be seen in the image below:
The thing to note is the writing of a string (text) should be in quotes ( '') begins the word and an end, ie to Spaso be written as "" or insert the name written word "name". Meanwhile, if using Data Number (numbers) do not need to be tabda quotation, quite in place the total alone as an example in Cell C6 adding the number 2 after B6.
2. Combine Data with CONCATENATE Function
To combine data from multiple cel in Excel than using the operators 'and' can also use an Excel formula or function CONCATENATE. CONCATENATE function is used to combine multiple Cell into the Cell or combine several text items into one text item. Syntax writing or formula basically is:
= CONCATENATE (Text1; Text2; ...; Text 225)
Examples CONCATENATE combines data is as follows:
By using a different way but the result remains the same, so the aggregate data from multiple cells in Excel up to you want to choose the means which have been provided above, use the first way (with the operator '&') or the second way to use formula (with CONCATENATE Function)
So easy and simple if you all work and understand all Excel, not hard and the marsh, just need to understand and learn berbabanyak.
If you like the same this post do not forget SHARE and G +
Demikianlah Artikel How to Combine Two Cell in Excel [ Version English ]
Sekianlah artikel How to Combine Two Cell in Excel [ Version English ] kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel How to Combine Two Cell in Excel [ Version English ] dengan alamat link https://belajaroffice2017.blogspot.com/2017/04/how-to-combine-two-cell-in-excel_13.html
0 Response to " How to Combine Two Cell in Excel [ Version English ]"
Posting Komentar