excel remove carriage return on mac

Use a formula to substitute the carriage return with your required substitute.

Example:

=SUBSTITUTE(A643,CHAR(13),". ")