Skip to main content

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!

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.

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

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

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

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


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

Terms & ConditionsAccessibility statement