Good Morning all, Excel amateur here again in need of some help.
I'm trying to add this text Account Number:
before this formula,
B6 is the account number on another sheet. Could someone please show me the formula for this?
Thanks in advance
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