Forum Discussion

Paneross's avatar
Paneross
Copper Contributor
Aug 05, 2019

Add Text Before a Formula

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

Excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 05, 2019

    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

    • neilkeenan's avatar
      neilkeenan
      Copper Contributor
      Feb 23, 2024
      Hi,

      Similar query here. I'm trying to use this formula but the value I'm trying to capture is a percentage. When I user the formula it gives the percentage in decimals instead of %.

      ="Brokerage"&L2

      I want this to say "Brokerage 3.5%" but it comes up with "Brokerage 0.035". Is there a way to show it as it's % equivalent? I've tried formatting as percentage but no luck.
    • profast's avatar
      profast
      Copper Contributor
      Nov 28, 2022

      HI thereHaytham 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)

       

Resources