Google Sheets - Concatenate (or, in layman terms, join together...)


(Part of my administrative assistant series on Google Sheets.)

The other task that can be labor intensive without a formula is joining fragments together into a single cell.  I can actually remember spending a whole DAY once creating student accounts that followed a certain pattern so I could upload them for auto-account creation in an online system.  This was for a single grade...and certainly not so "auto" especially considering I could have saved my day as there is an EASY way to do this :-)

Similar to SPLIT, the formula needs to be applied to each item you want to split - however, using the fill capability can make that quick work.  

CONCATENATE
Joins data together in one cell; it can use cell references and/or fixed data.  If it is only 2 pieces of data, it can be shortened to CONCAT

Example: =CONCAT(C2, "19")
This will join the value of 19 to the value that is in C2.
Here is an example of it - 

Example: =CONCATENATE(B2, ".", C2, "@nowhere.com")
This will create a string that has the [value of A2].[value of B2]@nowhere.com
Here is an example of it - 

Now, there is another way to accomplish this...and it does not require a "formal" formula.  Instead you can use the ampersand (&) between the fragments you are joining.  
Example: =B2&"."&C2&"@nowhere.com"
This will also create a string that has the [value of A2].[value of B2]@nowhere.com
Here is an example of it - 

Popular posts from this blog

Google Script - Create a Drop-Down List from Spreadsheet Column

Google Calendar - How to Share Your Calendar Via Link

Google Documents - Creating Page Anchors (aka Bookmarks)

Google Mail - Create Calendar Event that Includes Email Message

Google Contacts - Newest Area to Get Some "Google Love"