Excel formula to populate fileAs column with another column (remove outside ' ')
'="8:"&A2' (remove outside ' ' ) and fill down, finished!
The zimbra server will not populate the fileAs field using any of the normal codes 1-7 using data from the fullName field, so I had to do this manually for my data source which did not include first, last data. I used the 8th data type '8:John Doe' (remove outside ' ' these were to keep the forum smileys from replacing the 8: )