Excel How to Use Concatenate Function

Excel How to Use Concatenate Function

This video tutorial explains how to use the CONCATENATE function as well as "&" sign to combine several strings into just one string. In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.

Format Concatenate & Sign
RomeoCostillas =CONCATENATE(B4,C4) =B13&C13
ElainePaña =CONCATENATE(B5,C5) =B14&C14
Elijah Manuel =CONCATENATE(B6," ",C6) =B15&" "&C15
Romeo Costillas =CONCATENATE(B7," ",C7) =B16&" "&C16
Paña, Elaine =CONCATENATE(C8,", ",B8) =C17&", "&B17
Manuel, Elijah =CONCATENATE(C9,", ",B9) =C18&", "&B18
Ysabel-Eugenia =CONCATENATE(B10,"-",C10) =B19&"-"&C19

Download Practice File:

When you combine ignorance and leverage, you get some pretty interesting results.
- Warren Buffett

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:

YouTube Playlist:

See you there!

Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert

"To EXCEL in the workplace, one must know how to use excel!"
- Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy

[romeocostillas]

#excel #microsoftexcel #excelbyromeocostillas

[DazzleMaine]

ganun lang pla yun.. atleast ngaun alam ko na.. thanks for sharing bro..

[teloctv]

Wow galing, ganyan Lang pala, ngayon alam ko na paano pag gamit ng concatenate function.

[helenpana]

Just wondering if this is the same as concat. Please let me know. Thanks

[TheEnkandiosaGoals]

This is very useful and helpful especially for heavy excel users. Nice one! 😊😊😊👏👏👏