Inconsistent data from Lookups and other issues


Pulling a list of items from a multi-select field through a lookup provides a nice comma separated list. When that exact data is used in a formula, to join text for instance, the nice comma separated list is replaced a truncated list without any commas.

Data pasted into an external source into a single line text field can often be turned into a multi-line comma delimited field upon export to CSV. Line-breaks shouldn’t exist in a single-line field.