# Take Certain Text In Cell

**URL:** <https://community.glideapps.com/t/take-certain-text-in-cell/23806>\
**Category:** Ask for Help\
**Created:** [March 5, 2021, 8:34am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806 "2021-03-05T08:34:07Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 5, 2021, 8:55am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/4 "2021-03-05T08:55:03Z")

</div>

1. To get 21 out of 2021, one way is to use math:  
Create another column "Split Year"which subtracts 2000 from year column (2021) to get 21,
2. To get 03, you may create another column “Month Number” and use if-then-else to create number out of Month name “March”. For example: If Month = March, then value of Month Number is equal to 3 and so on.

---

_[View the full topic](https://community.glideapps.com/t/take-certain-text-in-cell/23806)._