I have a report listing certain information. Because that report is then exported to Excel format for distribution, the name field is concatenated, Last name, first name, preferred name on a new line.
Looks something like this:
=[LastNM]&", "&[FirstNM]& Chr(13)& Chr(10)&[PreferredName]...