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

Recover images from damaged SD card

Hai friends, Today I will give some tricks and tips to recover images from damaged SD card : A new, high-capacity SD card which is very smaller than a postage stamp — can hold lots and lots of files or images . If the card breaks or lost ,then you will miss entire files! There are times when a memory card just goes nonfunctional. You put it in the computer and it shows up blank, it's corrupt or ju st missing files . 1) Recuva and 2) Zero Assumption Recovery are two good applications to recover your lost files. These free file recovery applications will find hidden or removed items on memory cards . You can use them to recover files on flash drives and hard drives as well. After a scan, you might see your photos and other missing files. On recovering the files, be sure to save them to your hard drive. Don't try to save them to the memory card! If your card reader isn't broken and the card isn't externally...

create CON, PRN, AUX folder in Windows

Ever tried to create the following folder in Windows? CON, PRN, AUX, CLOCK$, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, & LPT9 Probably windows doesn't allow you to create a folder in these name using Windows Explorer or Command Prompt directly! This is because windows prevent these terms as SYSTEM Folder Names which are reserved for the Operating System. But there is a trick to create it. Trick for CREATING those folders: In command prompt, Type the following: md \\.\\C:\con This would create a folder named "con" on your "C Drive" i.e., md \\.\\(path where you want to create)followed by the name Similarly to delete such folder: Type the following in cmd: rd/s \\.\\C:\con This would remove the folder named "con".please note that rd(Remove Directory) command is used with "/s" switch as otherwise it would give error that "folder is not...

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...

Computer Tricks and Tips

Search This Blog