# Remove some elements from cell

**URL:** <https://connect.superhuman.com/t/remove-some-elements-from-cell/30735>\
**Category:** Ask the Community\
**Created:** [May 17, 2022, 3:25am UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735 "2022-05-17T03:25:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Giovanni\_Sades](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/giovanni_sades/32/21967_2.png) [@Giovanni\_Sades](https://connect.superhuman.com/u/Giovanni_Sades)\
**Post date:** [May 17, 2022, 3:25am UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/1 "2022-05-17T03:25:06Z")

</div>

I have a cell containing some elements (“Andy”, “Bill”, “Connor”, “Don”, “Edward”, “Frances”) in column 1.  
I also have a cell with some numeric values (4, 2) in column 2.

The numbers in column 2 represent the position of the elements in column 1 to be removed (“Don”, "Bill)

Te desired result would be the elements in column 1 without those in column 2 (“Andy”, “Connor”, “Edward”, “Frances”)

How can I do that?

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [May 17, 2022, 7:20am UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/2 "2022-05-17T07:20:34Z")

</div>

HI Giovanni\<

I am a little pressed for time, but the following link should be able to help you.

> [@Button to Modify Rows, Split First and Last Name](https://connect.superhuman.com/t/button-to-modify-rows-split-first-and-last-name/12840):
>
> Hi there! Totally new to Coda… apologies if this has been asked before (I looked and could not find anything frowning) I have a table of contacts. My client wants to be able to load in a CSV. The CSV has the First and Last name in one field, and my contacts table does not. I built a table view “Import New Students” to allow for him to copy and paste the CSV, and added two formula fields that split the first and last name up: [First Name (Import)] and [Last Name (Import)]. I want to finish it…

Regards  
Rambling Pete

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [May 17, 2022, 8:18am UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/3 "2022-05-17T08:18:21Z")

</div>

hi @Giovanni_Sades

one way to approach this you find below:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/0/2/0236863a480c5b5c46a9658157a4ac8547e91daf.png)

and this subset from step 01 you FormulaMap in step 02

 ![image](https://global.discourse-cdn.com/coda1/original/3X/2/9/29e0c9aee2685d5cbe5ca941fddbe8ae2c8cc642.png)

Hope it helps to find your way, Christiaan

---

<div class="post-metadata">

**Author:** ![Giovanni\_Sades](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/giovanni_sades/32/21967_2.png) [@Giovanni\_Sades](https://connect.superhuman.com/u/Giovanni_Sades)\
**Post date:** [May 17, 2022, 1:53pm UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/4 "2022-05-17T13:53:19Z")

</div>

Thanks a lot, Christiaan. I really liked your solution and it works nicely.  
I appreciate the time you took to take a look and reply.

---

<div class="post-metadata">

**Author:** ![Giovanni\_Sades](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/giovanni_sades/32/21967_2.png) [@Giovanni\_Sades](https://connect.superhuman.com/u/Giovanni_Sades)\
**Post date:** [May 17, 2022, 1:54pm UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/5 "2022-05-17T13:54:50Z")

</div>

Thanks, Piet. I’ll check this out.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [May 20, 2022, 1:55pm UTC](https://connect.superhuman.com/t/remove-some-elements-from-cell/30735/6 "2022-05-20T13:55:47Z")

</div>

Closed on May 20, 2022, 1:55pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.