HI Everyone, I need to concatenate two Text...

[Glenn_Thorne]

HI Everyone,

I need to concatenate two Text fields (Name and Address) with the result placed in a resultant virtual Long Text field (Full Address).

But I need a CR Newline character in between so the resultant virtual Long Text field (Full address) has the text on two lines.

Concatenate is easy but placing on two lines is still a secret to me.

In Excel it would be Chr (20) if I recall but in appsheet???

Ex

Bill Smith 123 First Street

[Glenn_Thorne]

Well I found an ugly workaround.

Put a formula =Char(13) in a Google sheets cell and then concatenate that in between strings above.

That will insert the Carriage Return.

But it works.

Should be an easier way though.

[Glenn_Thorne]

Nope, worked in formula test mode but strips the characters out in edit and view modes.

Help anyone??

[Bellave_Jayaram]

Put a line feed within the concatenate function like so: Concatenate([Name],” “,[Address])

[Glenn_Thorne]

@Bellave_Jayaram That works!

Ugly too but it does the trick.

@praveen would love to see a newline character available for string functions

Ex. Char(13)

[TalkNet_TechnoS]

Try to do this:
“Text1%0AText2” should view as:
Text1
Text2