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 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
