Pulling data from a field based on data in 2 fields
I import data where sometimes the persons name is in 1 field "Full Name" and sometimes I get the name in 3 fields "First", "Middle", "Last". I want to create a field "Final Name" that populates the field with the persons full name regardless of what method the persons name was imported. However I do sometimes import all 4 fields "Full Name", "First", "Middle", and "Last" just in case the solution needs to know that info.
I dont even know what type of function I would need to search for in order to learn how to accomplish this.
Thanks in advance,