String manipulation


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


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