Add Text Before a Formula

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

3 Replies

@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

HI there@Haytham Amairah  

I would like to do a similar function however i want the text as following.

 

i would like it to show the text and not FALS

 

="Dear"=C7

Result (FALS)

 

@profast That would be:

="Dear "&C7