# Add a backspace inside a "Insert Text Column" step

**URL:** <https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627>\
**Category:** Ask a question\
**Created:** [March 4, 2021, 5:42pm UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627 "2021-03-04T17:42:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Florent\_isidore](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@Florent\_isidore](https://community.parabola.io/u/Florent_isidore)\
**Post date:** [March 4, 2021, 5:42pm UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627/1 "2021-03-04T17:42:06Z")

</div>

Hi,

I have a “Insert Text Column” to concatenate two value but I would like to put a backspace instead of a simple space between the two value (my field is a “long text” field on Airtable, so it acceptes backspaces).

 ![Capture d’écran 2021-03-04 à 18.40.26](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/4509dc9c64259ed45ce88415b4a7105f2fb38657.png)

Is there a way to do this ?

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [March 5, 2021, 3:01am UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627/2 "2021-03-05T03:01:26Z")

</div>

Hi @Florent_isidore,

If I’m understanding correctly, you should be able to combine the values in each column by omitting the space between your text merge values.

Alternatively, if you want to remove the last character from a cell, try using the “Extract text from column” step to `find all text before` the end of your text and use an Offset Length of `1`.

 ![backspace](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/a/a4ded8aeb68bedb488416f4676fdad2312e70607.png)

Let me know if that helps!

---

<div class="post-metadata">

**Author:** ![Florent\_isidore](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@Florent\_isidore](https://community.parabola.io/u/Florent_isidore)\
**Post date:** [March 5, 2021, 7:02am UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627/3 "2021-03-05T07:02:56Z")

</div>

Hi Daniel,

Sorry, I wanted to say a “line break” instead of a “backspace”.

For example, if I have two columns with the following values “Hello” and “Florent”, I would like create a new column with the value  
“Hello  
Florent”  
and not “Hello Florent”.

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [March 5, 2021, 5:50pm UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627/4 "2021-03-05T17:50:16Z")

</div>

Thanks for clarifying!

Parabola cannot enter a line break directly into a cell. Taking a look at [this documentation](https://support.airtable.com/hc/en-us/articles/360041777913-Add-a-line-break-using-n#:~:text=By%20using%20%22%5Cn%22%20in,in%20line%20breaks%20as%20needed.&text=In%20order%20to%20see%20multiple,set%20to%20medium%20or%20larger.&text=For%20a%20more%20readable%20job,breaks%20in%20the%20right%20places.), you should be able to insert a line break by using \n when pushing data to Airtable.

Try switching your field type to a formula to see if that works.

---

<div class="post-metadata">

**Author:** ![Florent\_isidore](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@Florent\_isidore](https://community.parabola.io/u/Florent_isidore)\
**Post date:** [March 9, 2021, 8:51am UTC](https://community.parabola.io/t/add-a-backspace-inside-a-insert-text-column-step/1627/5 "2021-03-09T08:51:45Z")

</div>

Thank you Daniel, I will try that.

Best,