# Take Certain Text In Cell **URL:** \ **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:** 18\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 5, 2021, 8:34am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/1 "2021-03-05T08:34:07Z")
Hi all, Hope you are doing good. Here I am again 🙂 My attention is to create running number. Eg : GE-2103-1000-Rev.0 User will enter the date and other details and running number will create by his own. From the date, 21 in the beginning refer to the year. 03 after refer to the month from the date entered. 1000 will add 1 in the next after. (1001,1002,1003 etc) 0 at the last will change/update to 1 or 2 or 3 when they edit(make some revise). My question is there any ways to take certain text from one cell? ---
**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:44am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/2 "2021-03-05T08:44:42Z")
Hi Biha, As I understand, you would like the running number to be generated from the details entered by the user, you can use the template column to create a new value from values in other cells. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 5, 2021, 8:48am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/3 "2021-03-05T08:48:36Z")
But how to take for example the number 21 only for the year 2021 and 03 for the month of march? ---
**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")
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. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 5, 2021, 9:23am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/5 "2021-03-05T09:23:13Z")
Good idea! Do you have any idea on how to do running on 1000 . It will be cumulative column : 1000 1001 1002 1003 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 5, 2021, 9:26am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/6 "2021-03-05T09:26:31Z")
> [@Auto Numbering](https://community.glideapps.com/t/auto-numbering/20355/12): > > Here is how I would do it: “Padding” is just a simple ITE… So putting all that together, 4 columns required: Rollup to determine the current max order ID Math column to increment that by 1 ITE column to determine how many zeros required for padding Template column to join 2 & 3 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 5, 2021, 9:31am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/7 "2021-03-05T09:31:34Z")
Hi, thanks for replying. It same idea with @vijay . Do you know how to make the number cumulative as go down? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 5, 2021, 9:50am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/8 "2021-03-05T09:50:50Z")
Please refer to the solution in the link that I gave you, as that’s _exactly_ what it does. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [March 5, 2021, 9:51am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/9 "2021-03-05T09:51:39Z")
For the date in yymm format (YEAR (D) -2000) \* 100 + MONTH (D) where D is the date or Now ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [March 5, 2021, 9:59am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/10 "2021-03-05T09:59:07Z")
And for 1000 … 1001 Math column 1000 + X where X is your base number ---
**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, 10:02am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/11 "2021-03-05T10:02:29Z")
In this case, are you trying to generate the next row value in a column from the previous row value. Meaning, if ID is 1000 in the ID column in row 20, then in row 21, the ID column should have value 1001, right? Darren’s and Manu’s solution will generate in the same row, but to generate in the next row will require a different solution. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [March 5, 2021, 10:06am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/12 "2021-03-05T10:06:14Z")
ah for an ID + 1 Add a Rollup / Max column with your ID as reference, then use the math formula 1000 + X to format your number ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 5, 2021, 10:07am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/13 "2021-03-05T10:07:09Z")
> [@vijay](#): > > Darren’s and Manu’s solution will generate in the same row, but to generate in the next row will require a different solution. My solution provides an auto-incrementing column. So every time a new row is added, the number in that column will auto-increment by 1. Is that not what he is looking for? ---
**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, 10:08am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/14 "2021-03-05T10:08:43Z")
It has to percolate to the next row. Can the next row have the auto incremented value in the same column? I guess that is what he is looking for. For example, the user need not enter the ID again for the next row. It will be autogenerated. In your solution, it is happening in the same row. How would that be used for the next row entry? ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [March 5, 2021, 10:19am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/15 "2021-03-05T10:19:17Z")
there is already the solution in the subject of @Darren_Murphy If you read the whole thread, you have the solution to increment an ID then format it > [@Take Certain Text In Cell](https://community.glideapps.com/t/take-certain-text-in-cell/23806/6): > ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 8, 2021, 1:02am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/16 "2021-03-08T01:02:32Z")
It is looks like this. but where is the ID? hmm sorry dont get it. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db920d46d937ae79b09921dd5f236e079880a9dc.png) ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 8, 2021, 2:20am UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/17 "2021-03-08T02:20:47Z")
For those who are reading this topic, here is the solutions. Applying both. > [@Take Certain Text In Cell](https://community.glideapps.com/t/take-certain-text-in-cell/23806/4): > > 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, 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. > [@Take Certain Text In Cell](https://community.glideapps.com/t/take-certain-text-in-cell/23806/6): > ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/take-certain-text-in-cell/23806/18 "2024-01-17T16:53:06Z")