AnsweredAssumed Answered

Weird text concatenation

Question asked by vincedubeau on Apr 20, 2018
Latest reply on Apr 21, 2018 by fmpdude

A simple calculated field: Last Name & ", " & First Name.

 

It works great 95% of the time but sometimes inserts a CR after Last Name. I fixed it by using Substitute to replace the CR with "". I just don't understand why this happens occasionally. Just curious if anybody else has seen this behavior.

Outcomes