Forum Discussion

Las's avatar
Las
Frequent Visitor
4 years ago

Converting Text Column having Text and Scientific Notation

Hi Experts, I'm having a text columns with numbers, text and scientific notation, example as follows   202-203 2320042 AH3021 F21A-001 1.00E+11   In a situation like this how to handle the d...
Need Help
Las's avatar
Las
Frequent Visitor
4 years ago

Thank for all your responses.

 

I might be looking for power query to convert the exponential values and rest of the other values in the column to text. The issue is after converting it will error out all the other values which is not having scientific notation. 

 

When having multiple values ( mix of text, SN and general types ) how to handle this situation?

 

Thank you

Regards,

Las

 

 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Power Query equivalent is Text.From like below

= Text.From([Column1])