How to maintain text formatting from custom columns in text visuals

[Johnnyg]

I have created a custom column with formatting (#(cr), #(tab), #(lf),...) for the intent of displaying the format in the text box visual.

when I apply the query, the formatting is lost.   How can I create a column that will concatinate strings and formatting such that it will display with that formatting in my visuals?

For example:

Column = [Name] & "#(lf)" & [Address] & "#(lf)" & [City] & ", " & [State] & "  " & [Zip] & "#(lf)" & [Phone]

To result in Text visual as follows:

John P. Jones

1121 S Andrews St

Faraway, NM, 09876

(123) 456-7890

I have searched the community, but have not found either the visual or the structure to maintain format into the visual.

[Johnnyg]

To add clarity:

The custom column should result from all columns being Text type 

FullAddress = [Name] & "#(lf)" & [Address] & "#(lf)" & [City] & ", " & [State] & "  " & [Zip] & "#(lf)" & [Phone]

and the column's values would be formated text (like Excel does it).

Resulting in a formatted field in the custom column (FullAddress) as such:

John P. Jones

1121 S Andrews St

Faraway, NM, 09876

(123) 456-7890

Then using a text visual, I can list the Full Address (formatted as above) WYSIWYG

The format shows in the custom column (FullAddress), but when the query is applied the format is lost. 

Wonder if this is a know issue???  Or, am I going at this with the wrong approach???

Thanks for your response to this newbe.

[BhaveshPatel]

Seems unusual. Make sure to save your file at each step. 

I tried to recreate your solution but it doesn't happen to my version. 

[Johnnyg]

Thank you for your quick response.   Very interesting differences of experiences.   Are you creating the column in Query Editor? 

Thanks!!!

[BhaveshPatel]

All the columns should have a same data type to concatename them together.

In your case, it should be the text data type for all the columns to join them together.