Formula to combine address fields?
How do I add linebreaks to a formula field so I can combine separate first name, last name, address, city, state, and zip code fields into one field that looks like this:
first name last name
address
city, stae zip code
6 replies
-
Bleep! If I could edit on this forum I would be able to correct my spelling errors, but NO.
-
Like this:
FirstName + “ ” + LastName + “
”+ Adress + “
”+ City + “, ” + State + “ ” + zipcode
notice the returns after the “ for another line.
Steven
-
Thanks RoSoft_Steven Rooryck. I had to add some spaces to get Ninox to accept the formula. This is the one that works:
“First Name” + “ ” + “Last Name” + “
” + Address + “
” + City + “, ” + State + “ ” + “Zip Code” -
Well, I dit it like this (with no spaces) because single quotes are converted to double quotes on my screen in this forum and I would have mislead you... Tried also with other browsers and on my Ipad also. Still doubled. Am I the only one who sees double quotes when it“s supposed to be single?
Single quote: ”
Double quote: “
ps:On your post I also see double quotes round your fieldnames. Do you also see them?
What”s goin on in this forum.....
Steven
-
Yep. The forume (horrible interface) is converting all single quote marks to double quote marks. Continues to show how important a new forum would be. This one is SO BAD.
-
And don“t spell anyhting wrong and think you could edit to fix it. NOPE.
Content aside
- 3 yrs agoLast active
- 6Replies
- 631Views