Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Error in column

Hi,   I have a column formated as text with 2 types of data. 1) 12345 and 2) AB123. Now I am looking for a way to have them in same column without Error   thanks  
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

The same column can only have one type, because some values in a column in your data contain non-numeric characters, so it cannot be converted, if you can, can you give some examples and the result that this example hopes to output?

I don't  understand what you want to do.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    i want to change type of column to any so it will remove the Error so it can read of them 
    1) 12345
    2) AB123.
    thanks