Thanks.
Avoiding that spreadsheet thing with formulas, etc. was the reason to ask.
Having multiple columns with the same content in different capitalization introduces redundancy and manual effort.
Also sometimes the startlists have a different format in regards to the capitalization.
Using the "PC-function" would ease up things.
Also sometimes there are special characters in the names that we need to avoid in the metadata (German chars like äüöß, etc) This could be done by the "TR"-feature like [[Firstname]:tr:ä/ae:tr:ö/oe:tr:ü/ue/tr:ß/ss]
@Max: Having clients that needs the persons in the format LASTNAME, Firstname, others as Firstname Lastname or Firstname LASTNAME.
With the option of modification you only need one column for firstname and one for the lastname and let PM do it's magic.
Caption: [Firstname], [Lastname] bla bla bla
Other field: [[Lastname]:UC], [Firstname]
See the example section here:
https://docs.camerabits.com/support/solutions/articles/48001077381-variable-substring-extraction