With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, February 26, 2018
yogi_Entries in Column A In Two Columns With Period (.) As The Delimiter
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.