=Concatenate

Screen Shot 2014-07-09 at 12.15.15 PM

 

Anyone who works with spreadsheets will tell you that there are times when you need to combine the data from two cells into one. Recently I ran into this issue when creating my class rosters. I had a cell for first name and one for last name. What I needed was one cell that contained both first and last name. At this point I had a choice. I could either rewrite them all or use a function to auto populate the fields.

I really didn’t want to spend hours typing in names so I used a function. Earlier in the day my schools Director of Technology taught me about the CONCATENATE function.

The CONCATENATE function takes data from different cells in a spread sheet and combines the data into one cell.

For example I was able to use this function to combine the data in my first name and last name cellsĀ into one cell. Below is a breakdown of how the function works…..and yes it works in both Excel and Google Sheets.

 

concatenate

So the next time that you need to combine two pieces of data into one I would highly recommend using the CONCATENATE function. It’s a huge time saver!

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *