List Name and Division properties of users whose specific attribute is Not Null

 

Get-ADUser -Filter * -properties division | where division -ne $null | Format-List -Property Name, division