Aug 05 2019 06:26 AM
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
Aug 05 2019 06:51 AM
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
Nov 28 2022 01:26 AM
HI there@Haytham 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)
Feb 23 2024 04:15 AM
Feb 23 2024 04:23 AM
@neilkeenan That would be:
="Brokerage "&Text(L2,"0.0%")
Feb 23 2024 06:26 AM
Another option is to apply custom number format to the cell
which keeps in the cell number formatter as above, not text.