I need to know which formula I can use that will produce the following result with the following existing data:
Column A, Row 2 - (Cell A2) - Value is 200806140804
Column A, Row 3 - (Cell A3) - Value is 200806150805
Column A, Row 4 - (Cell A4) - Value is 200806160806
Is there a formula I can enter in Column B, Rows 2, 3, 4 that will allow me to drop the last 4 digits for each of the values?
My data is much larger than 3 rows, but for simplicity, I narrowed my question down to 3.
Thank you so much!
September 3, 2010 4:41 PM
September 8, 2010 2:21 AM