Address Book Help

Question

I have a spreadsheet that I am working on making compatible with QuickBooks. My spreadsheet includes 4 columns:

Name	First Name	Last Name	Company
Todd, Liz	Liz	Todd
Microsoft Co			Microsoft Co

I need the Name Column to copy "Company OR Last Name, First Name" as shown in RED

I have used =C2 & "," & B2 but it does not give a space between the "," and the first name.

If I add D2, it still includes "," which drives me crazy.

I'd appreciate the help!

Answer 1

Hi,

In cell A2, enter this formula and drag down

=IF(D2="",C2&", "&B2,D2)

Hope this helps.