Forum Discussion

Hindlaz's avatar
Hindlaz
Frequent Visitor
2 years ago

Export Number from text as paragraph

Hello,

 

I'm begginer her so I need your helps pls. I dont have right to transform data so I can only create new column 
I have a column format text but it contains numbers with (.) as paragraph, I would like to transfer this column to number in order to sort my Data per the number. Because when I sort my data with the column as it is,.

I tried Newcolumn = LEFT(column2[ID],3 SEARCH(",",column2[ID])-1) but message error show that i cant transfer text to number

 

It shows like this

Thank you in advance.