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!
String manipulation
+6This topic has been closed for replies.
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.
+2Is 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.