Thread: [Solved] Formula for creating Account Name
View Single Post
 
Old 03-11-2015, 11:52 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
I inserted another column in D for Account with this formula for the first row of data:

Code:
=TRIM(IF(ISBLANK(F2),"",F2 & " ") & G2 & " " & IF(LEFT(C2)="H", "Household","Organizational"))
Reply With Quote