Skip to main content

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

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

KEYBOARD SHORTCUTS FOR WINDOWS 8 :

KEYBOARD SHORTCUTS FOR WINDOWS 8 :  Hai friends, The following are keyboard shortcuts for windows 8 users.I hope that this will make your Windows 8 experience much more enjoyable! I. On Pressing the Windows key + I will open the Settings at side of the screen i.e,. the charms. II. Press and hold the Windows key + D to open the Windows Desktop. III. Press and hold the Windows key to open the Start screen . ... If your are in start screen , then you will be switched to desktop on pressing windows key! IV. Press the Windows key + Print screen to create a screen shot, which is automatically saved into your My Pictures folder. V. Press the Windows key + C to open the Charms. VI. Press and hold the Windows key + Tab to show open apps. VII. Press the Windows key + X to open the power user menu at the lower left corner. This menu allows you to choose various windows tools and work with them as shown below!!   TRY THIS FRIENDS     ...
Post a Comment
Read more

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...
Post a Comment
Read more