TUG Tips & Tricks: General

Using the ampersand "&" as a shortcut for the concatenate function in Excel

Wednesday, October 2, 2024 (0 Comments)
Posted by: Jackie Hazlett

Share |

TUG Tip -- General Knowledge

Using the ampersand "&" as a shortcut for the concatenate function in Excel

The CONCATENATE or CONCAT function in Excel can be used to join data from multiple cells into one string. Instead of typing out CONCATENATE or CONCAT, an ampersand "&" can be used instead. For example instead of =CONCATENATE(A1,B1) use the "&" to shorten to =A1&B1

« Back to Index

Tips & Tricks more

10/22/2025Working in the Items List (SQL)

10/15/2025Adding Reports to Sage's Homepage

10/8/2025File Names - Short & Clear is Best

Calendar more

10/28/2025
Project Management (Sage 300 CRE) BRING YOUR OWN QUESTIONS & User Community Meeting

11/3/2025
TUG Membership Committee Meeting

11/4/2025
Sage Intacct Construction User Community Meeting

11/4/2025
Sage 300 CRE Change Management Basics - Workflow & Change Requests

11/5/2025
TUG Social Media Committee Meeting

	Edit This Favorite
Name:
Category:
Share:	Yes No, Keep Private

About Us	Membership	Knowledge Exchange	Events	Resources
About	Join Now	Advocate to Sage	Community Calendar	Get Connected ⇓
Leadership ⇓	What Members Say	User Communities	Year-End Webinars	Vendor Members
TUG Board of Directors	Member Orientation	Committees	National Conference	Associate Members
TUG Past Presidents	Get Involved	Advertise with TUG		TUGweb Tutorials
TUG Staff	Follow Us on Social Media			FAQs
Contact Us	Get Rewarded			Career Center

The Users Group for Sage Construction and Real Estate Solutions

Edit This Favorite

Using the ampersand "&" as a shortcut for the concatenate function in Excel

TUG Tip -- General Knowledge

Using the ampersand "&" as a shortcut for the concatenate function in Excel

Connect with TUG