Lesson#45: “&” can replace the function CONCATENATE

Lesson#45: “&” can replace the function CONCATENATE

If you know the use of the character “&” then it can replace the function CONCATENATE.

You can join one or more numbers or texts using “&” between them to convert them into a single text.

Place “&” and other characters or phrases or texts to join into a single phrase.

Use “&” with the formula easily to add any text or value from any other reference easily with the result.

Related Video Tutorials:

See also  Lesson#248: SUMIF and SUMIFS Functions: Conditional Summing

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

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

*