Error when having letters and numbers within a cell

[BrittanyBoyer]

Hello,

I have tried changing this column to text and to number however; I am receiving the below error as some of the information within these cells have a letter and a number. Can you please advise on how I can resolve this?

[pratyashasamal]

Hi @BrittanyBoyer ,
Please check out this link to troubleshoot the dataformat error :-
https://rukiatu.com/how-to-audit-and-fix-dataformat-error-in-power-query/
Also please share the applied steps , this error usually happens due to some of the previous applied steps.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Dipanz]

It didn't scum

[Saurabh8437]

Hi,

you might have two changed type steps in the Power Query, remove the first changed type step which converts this column into the number.