# Concatenate, format and display
**URL:** https://community.glideapps.com/t/concatenate-format-and-display/13212
**Category:** Ask for Help
**Created:** [July 28, 2020, 4:57pm UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212 "2020-07-28T16:57:56Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Raghavendra\_Srinivas](https://community.glideapps.com/u/Raghavendra_Srinivas)
#### Post date: [July 28, 2020, 4:57pm UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/1 "2020-07-28T16:57:56Z")
I’ve below data in google sheet:
## Column A | Column B | Column C | Column D
text A | text b | text C | RESULT HERE
Now I want to read the different text values (statements) in each of the columns, concatenate all the text while formatting at the same time, and display the result in Column D.
The formatted result should look like below:
**Text A in bold**
\*\*
- Text B in bold in next line and indented once (one level)
\*\*
- Text C not in bold and indented twice (two levels)
something like
**Text A.**
- **Text B** (first level indentation must be here)
- Text C (second level indentation)
Unfortunately, I’m stuck when I use ARAYFORMULA in the sheet column D, the result accepts line break and bold … but is ignoring indentations or may be I’m not providing indentations at the right place.
Below is the formula I am using in Column D:
=ARRAYFORMULA(“{b}”& A2 & “{/b}” & “{br} {b} -” & B2 & “{/b} {Br} --” & C2)
Obviously, I used \< instead of { and I used \> instead of } in the above formula.
Someone, please help me … I’m stuck here for 2 days …
I’m open to achieve this either by using array formula in google sheet or any alternate within glide app.
thank you 🙂
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 29, 2020, 12:55am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/2 "2020-07-29T00:55:03Z")
I suppose this is what you want.
I followed the Markdown format to make a template column in Glide then show it in a rich text component.
---
### Author:  [@Raghavendra\_Srinivas](https://community.glideapps.com/u/Raghavendra_Srinivas)
#### Post date: [July 29, 2020, 1:09am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/3 "2020-07-29T01:09:24Z")
Perfect! It worked.
I don’t know why it didn’t work earlier when I used - and space followed by -
Anyways, thank you so much.
By anyway, do you know how to remove a column in data manager in glide UI? There is column named TestC and when I click on that little down arrow I only see the option to edit but not delete ☹
This field isn’t there in the sheet.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 29, 2020, 1:12am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/4 "2020-07-29T01:12:22Z")
Can you make sure that it’s not in the sheet? It should only be undeletable if it is a Sheet column.
---
### Author:  [@Raghavendra\_Srinivas](https://community.glideapps.com/u/Raghavendra_Srinivas)
#### Post date: [July 29, 2020, 1:15am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/5 "2020-07-29T01:15:00Z")
Yeah, I do not see it in the sheet.
---
### Author:  [@Raghavendra\_Srinivas](https://community.glideapps.com/u/Raghavendra_Srinivas)
#### Post date: [July 29, 2020, 1:15am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/6 "2020-07-29T01:15:53Z")
Now it’s gone … may be the sheet didn’t load properly
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 29, 2020, 1:16am UTC](https://community.glideapps.com/t/concatenate-format-and-display/13212/7 "2020-07-29T01:16:27Z")
Okay, tell me if I can help more 😄