Description:
Combine Text, Numbers, Symbols & Dates in Excel Using CONCAT() !
Have you ever needed to merge text, numbers, dates, and symbols into a single cell in Excel? Maybe you want to combine first name and last name, add a currency symbol, or turn a date into a readable sentence. In this video, you will learn how to do that using CONCAT(), Excel’s function for combining values. Excel used to have a function called CONCATENATE(), but that’s now replaced by CONCAT(). By the end of this video, you’ll be able to combine text, numbers, symbols, and even dates! Sounds interesting? Check it out!
Other related resources to this video:
~ Combine Text, Numbers & Symbols in Excel with & Ampersand!
https://www.youtube.com/watch?v=KYYMPzXH0L8
~ Combine Text, Numbers, Symbols & Dates in Excel Using CONCAT !
https://www.youtube.com/watch?v=C_KF3sXPj-c
~ Combine Text, Numbers, Symbols & Dates in Excel Using TEXTJOIN!
https://www.youtube.com/watch?v=9v8eXedZfl4
By Cedric Ng,
AUTHOR of International Best Sellers,
“Predictive HR Analytics, Text Mining & ONA with Excel” &
“IISS: Employee Experience & Engagement with Predictive Analytics”
~ Subscribe to my YouTube channel at: https://www.youtube.com/thehrdiary
~ Check out Books at: https://www.amazon.com/s?k=ng+mong+shen
Share this link via
Or copy link