• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

CONCATENATE

The CONCATENATE function is one of the more useful functions you’ll find in Excel. CONCATENATE can be used to join text in several forms. One reason it’s useful is when you inherit spreadsheets from other creators you’ll often need to clean up the cells and text. Often, this includes the combination of information within one cell and this is where concatenate comes in.

=CONCATENATE(text1,text2,...)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint