yogi_Entries in Column A In Two Columns With Period (.) As The Delimiter

Google Spreadsheet   Post  #2383

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-26-2018

question by: Joan Sw
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/QLQ0I5yElnM;context-place=mydiscussions
Split function not working right with numbers and the letter E

I have a variety of number/alphanumeric combinations in a column.

See column C below.

I use this formula in Column E: =IF(IFERROR(SPLIT(C262,"."),"") <> "", SPLIT(C262,"."),"")

The column format for C is Number --> Automatic.

For some reason it does NOT like to split properly on the 9E-1.01 values.

What can I do to resolve this?

Thank you.