Google
Search WWW Search BSL
  Home >> Products >> Advanced Calendar for Excel  >>  Advanced  >> ...
 

The program works assuming that you have stored your data in the following format:

  • Column A contains the Date (MS Excel Date Format)
  • Column B contains the L1 (Line 1)
  • Column C contains the L2 (Line 2)

The following cases are available in this section

Case Description
A

Setup file definitions

B Date, L1, L2 stored in different columns
C Date, L1, L12 , L2, L22 stored in different column (Note 4 Columns to be displayed as L1 and L2)
D Date is a part of string and has a known FIXED start position
E Date is a part of string and has a known FIXED start position and FIXED end position
F Date is a part of string and has a known CHARACTER start position
G Date is a part of string and has a known CHARACTER start position and known CHARACTER end end position.
H How to use the Begin Date and End Date Database sheet.
 
  © 2008 BaRaN Systems LLC. All rights reserved.