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.
Tuesday, April 19, 2011
yogi_Splitting Text Entry With Numerics Without Suppressing Leading Zeros
Spreadsheet field contains property parcel numbers in the format: a99 999 999. I am using SPLIT formula =SPLIT(A1," ") to break the field apart into three chunks each in a separate column. SPLIT is deleting leading zeros on numeric chunks. I have set all columns to "plain text". Still deletes leading zeros. Please advise.