Forum Discussion
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...
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,
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.
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.
neilkeenan That would be:
="Brokerage "&Text(L2,"0.0%")
- Perfect. Thanks
Another option is to apply custom number format to the cell
which keeps in the cell number formatter as above, not text.
