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.neilkeenan That would be:
="Brokerage "&Text(L2,"0.0%")
- Perfect. Thanks
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)
profast That would be:
="Dear "&C7
