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

Puspendu Roy Karmakar Posted on February 8, 2018 Posted in Excel Funtions, Excel general tips No Comments

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:

About Puspendu Roy Karmakar

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.