Create a calculated field Like "your prefix "+[fieldname]
If you have [Gender] you could do WHEN [Gender] ="Female" THEN "Mrs" or something like that.
Then the Calculated Field becomes [CF - WHEN THEN]+" "+[fieldname]
This is assuming [fieldname] is a String to begin with.
Perfect! Thank you!