Home

Add Text Before a Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-788132%22%20slang%3D%22en-US%22%3EAdd%20Text%20Before%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788132%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%20all%2C%20Excel%20amateur%20here%20again%20in%20need%20of%20some%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20add%20this%20text%20%3CSTRONG%3EAccount%20Number%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ebefore%20this%20formula%2C%3C%2FP%3E%3CP%3E%3D%E2%80%9D'Employer%20Summary'!B6%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EB6%3C%2FSTRONG%3E%26nbsp%3Bis%20the%20account%20number%20on%20another%20sheet.%20Could%20someone%20please%20show%20me%20the%20formula%20for%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788178%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20Text%20Before%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788178%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377119%22%20target%3D%22_blank%22%3E%40Paneross%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20absolutely%20easy%20as%20follows%3A%3C%2FP%3E%3CPRE%3E%3D%22Account%20Number%3A%20%22%26amp%3B'Employer%20Summary'!B6%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20you%20need%20is%20to%20put%20the%20text%20in%20double-quotes%20and%20join%20it%20to%20the%20formula%20using%20the%20ampersand%20operator%20%3CSTRONG%3E%26amp%3B%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
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