Do you need a Full Name field to import into a particular program? But, you only have First Name and Last Name fields in Excel? There are many times when you need to Merge or Join Cells in Excel - this tip shows you how easy it really is:
Insert a New Column.
Type =CONCATENATE(Cell1,Cell2,etc)
Using the formula above, here is an example of the results:
Cell1 Cell2 Cell3 RESULTS
Go Ask Debbie GoAskDebbie
If these are the results you wish, simply Copy the formula down the column to include all rows you wish.
But, let's say you need a Space or a Comma between each of the cells once they have been merged. To do this, type your formula as follows:
=CONCATENATE(Cell1," ",Cell2," ",etc)
This would create the following result from the above scenario "Go Ask Debbie". Notice now there are spaces between the cell contents.
Get creative this can help you create many different types of results.
Subscribe to:
Post Comments (Atom)
-
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
-
I've had a few people ask me lately how to filter lists using Excel. It really is as simple as clicking a button on the Ribbon. If you...
-
When Outlook is first setup, the default Auto-Archive is 6 months. This means that e-mails dated 6 months ago will automatically be moved...
No comments:
Post a Comment