Combine the content of two cells into another in Excel

How to Combine the content of two cells into a Cell?

Hi everyone! Want to merge the content of two cells into another in Excel? This will be helpful if you have the worksheet as shown!

This file has first and last names in separate columns. You can easily combine them and show the result as a full name in another column.

=A2 & " " & B2 -->will give you "First Name Last Name"
=B4 & ", " & A4 -->will result in "Last Name, First Name"

We have first name in column A and last name in column B
In cell C2 enter "Full Name" as your column heading.
In cell C3 enter either of those formulas!

It is the ability to combine text from multiple cells into one cell.
Enjoy!

Comments

Various Units and their equivalents in Computer science

Various Units and their equivalents in Computer science 1 Bit = Binary Digit 8 Bits = 1 Byte 1024 Bytes = 1 Kilobyte 1024 Kilobytes = 1 Megabyte 1024 Megabytes = 1 Gigabyte 1024 Gigabytes = 1 Terabyte 1024 Terabytes = 1 Petabyte 1024 Petabytes = 1 Exabyte 1024 Exabytes = 1 Zettabyte 1024 Zettabytes = 1 Yottabyte 1024Yottabytes = 1 Brontobyte 1024 Brontobytes = 1 Geopbyte 1024 Geopbyte=1 Saganbyte 1024 Saganbyte=1 Pijabyte Alphabyte = 1024 Pijabyte Kryatbyte = 1024 Alphabyte Amosbyte = 1024 Kryatbyte Pectrolbyte = 1024 Amosbyte Bolgerbyte = 1024 Pectrolbyte Sambobyte = 1024 Bolgerbyte Quesabyte = 1024 Sambobyte Kinsabyte = 1024 Quesabyte Rutherbyte = 1024 Kinsabyte Dubnibyte = 1024 Rutherbyte Seaborgbyte = 1024 Dubnibyte Bohrbyte = 1024 Seaborgbyte Hassiubyte = 1024 Bohrbyte Meitnerbyte = 1024 Hassiubyte Darmstadbyte = 1024 Meitnerbyte Roentbyte = 1024 Darmstadbyte Coperbyte = 1024 Roe...

How to repair/fix the booting problem in Windows 7 or 8?

Problem with windows boot? Are you getting error message like “Reboot and Select proper Boot device Or Insert Boot Media in selected Boot device “ while at startup? Windows 8 has upgraded the desktop side by including a few tools within its troubleshooting asset. You can primarily attempt to fix the booting problem using Startup Repair You can also choose cmd to fix this problem. The might be with MBR. Now what is MBR? “MBR is one to boot your windows computer, it’s a small file which initiates the booting process ” Discovering a corrupt MBR, boot sector, or Boot Configuration Data (BCD) is tedious process.Now I show how to fix this problem How to repair/Fix the MBR in Windows 7 or Windows 8? Then you can just follow the steps given below! Step 1) First of all, you will require a BOOTABLE DISC OR PEN DRIVE. It’s recommended that you isolate other storage devices like pen...

Protect you apps using a password

Want to protect your Software / apps by a passphrase ? Hello friends, today I gonna teach you a trick to protect your application softwares by a password. This avoids other users to open and launch an application .Those who know only password can customize it. Password Door is especially used to add passwords to programs. Once protected, the list will be kept secure in a simple window. At any time, users are free to Add, Remove, Modify and Enable the protection. If you are interested to protect your pc softwares with password then just follow below steps 1) First of all download “Password Door software” to your PC. 2) In the installation wizard , it will prompt you to enter a password as shown Now you can type a password of your wish!This will be used to open the password protected software...

Computer Tricks and Tips

Search This Blog