Home

Add Text Before a Formula

Paneross
Occasional Contributor

Good Morning all, Excel amateur here again in need of some help.

 

I'm trying to add this text Account Number:

before this formula,

=”'Employer Summary'!B6

 

B6 is the account number on another sheet. Could someone please show me the formula for this?

 

Thanks in advance

1 Reply

@Paneross

 

It's absolutely easy as follows:

="Account Number: "&'Employer Summary'!B6

 

All you need is to put the text in double-quotes and join it to the formula using the ampersand operator &.

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies