Remove part of a string

[Ken]

I asked about how to reference “cells” (or columns) in CONCATENATE() but later found that it gives you a choice to select columns within the function window. Sorry and thanks!

[Andrew]

Hey Ken, no worries! Glad you were able to figure out. Let us know if there’s a way that we could have made that more intuitive for you.

[Ron_Wessling]

Is it possible to add a carriage return within the CONCATENATE() function.

Name(carriage return)&Address(cr)&City&" “&State&” "&Zip

[Andrew_Enright]

Yes, you use “\n”, see here: Carriage Returns in CONCATENATE