Extract 3 positions from a number range

[MadiNissi]

Hi,

I have a column with data lenght of 45 numbers and just need to take the three numbers 111 of each row and create a new column to accommodate the results.

Can anyone help me with this?

35240841940351000160551110000009231951830810

Thank you.

[MadiNissi · Accepted solution]

Just got the solution.

I used formula with a new column and Substring function - Substring([mycolumn], 23, 3)

Thanks.