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.
Thursday, November 20, 2014
yogi_Convert Entries Ending With B M K Into Numbers As Billions Millions And Thousands
post by Timothy Niemeyer: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/69kHP9pVakE) Multiple Len, Substitute, Right (B ,M, or K) Conundrum
Problem Description: I'm importing data from a website that either gives a string, for example, 120B (billion), 134M (million), or 75K (thousands). I've been able to use the formula to turn it into a number if it's billions (B) or millions (M) but am having trouble accounting for thousands (K). Here's what I have so far...