Prefix/Suffix Column

This will add a prefix or suffix to the headers or the data in a column. The settings are:

Which column to prefix and suffix (optional): Type the column name(s) here. Separate columns by a comma (,). If this is left blank, the default is all columns.

Prefix (optional): If adding a prefix, type it here. Can be left blank.

Suffix (optional): If adding a suffix, type it here. Can be left blank.

Use regular expression (optional): Select this if you’d like to use regular expressions to identify the column names.

Use on data (optional): Select this if the prefix/suffix is being added to the data in the identified column(s).

Use on header (optional): Select this if the prefix/suffix is being added to the column headers.