How Do I Remove The Carriage Return Symbol From Cell Populated By A UserForm TextBox?

Yes. I would like fo rthe cell to reflect the layout from within the userform text box. So this in the text box:

address line 1
address line 2
address line 3

will be replicated in the cell it populates.

I currently have something like this in my userform code:

ActiveCell.Offset(0, 3) = txtLocation.Value
ActiveCell.Offset(0, 5) = txtReference.Value
ActiveCell.Offset(0, 11) = txtComments.Value