Hello,



Can you provide the formula for creating a column of Household accounts with the naming format:
FN LN Household. The FN and LN are in separate columns (Columns E & F), and the word Household is to appear after each FN LN. If there is no value on the FN column, the formula should allow LN to create the account name as: LN Household.

The Household accounts need to be listed in Column B - the same column as other accounts. Do I need to create a separate column for Household Accounts and then merge the 2 columns? I need to end up with one column "Accounts" that will contain both Household Accounts and Organization Accounts.

I've attached the spreadsheet for your reference.

Thank you in advance for your help on this!

Gef

Attached Files

2Test.UniqueNamesTestData.xlsx (33.0 KB, 16 views)