Wednesday, September 12, 2012

yogi_Split Cell Contents In Time Tracking Data Dump

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #742   Sep 12, 2012     www.energyefficientbuild.com.

user outlaw26r said: (http://productforums.google.com/forum/?zx=4yq9wcrgo0dm#!category-topic/docs/spreadsheets/hmFjPVy_M24)
Splitting Data cell results in 0 being removed from front of number (0178)
I am taking calendar data from my team that I have extracted from Google Calendar & I plan on weekly importing into my spread sheet titled Time Tracking Data Dump. I am then splitting the text in A:A to isolate the project number which will come before the ":" into columns F:G. This will enable me to pull all the relevant calender items that match the project number to another spreadsheet. My issue is that when I split the cell as seen in Column F3:G3, the project number is there, but it is missing the 0 in front of the 0178. This is crucial as I am already calling from several other spreadsheets by the project number so I can't just loss the 0. 
I have attempted to change columns A:A & F:F to plain text in hopes of retaining the true number but so far have not been successful. Any ideas would be greatly appreciated.
Thank you,
Outlaw26r
Justin

-----------------------------------------------------------------------------
following is a solution to the problem