hi all i want to creat formula as defined below-
-------------------------------------------------------------------------
formula needed for creating Student ID
Student ID looks like-
CC1/ACTI/12/13/000001
defination-
*Code *legend (Example of data in Cell) Range of data
--------------------------------------------------------------------------
CC1 - Course code - (basic computer Course) Around 50 Courses
ACTI- Center Code - (Alma Computer Training Institute) Around 10 Centers
12 - month code - (December) 12 Month
13 - Year Code - (2013) 2013-2099
000001 - Sr. No. - (1) numerical value 1-999999
------------------------------------------------------------------------
i have course codes as CC1 for Basic Computer Course , for all 50 Courses.
i have Centers Codes as ACTI for Alma Computer tra..., for all centers
month,year and sr. no. (serial number range given above)
i want that Excel should extract code from data in the cells.
Example-
----------------------------------------------------------------------------
Sr. Center name Course Date of Enrol. Code
----------------------------------------------------------------------------
1 ACTI Suraj BAsic Computer Course 31/12/13 CC1/ACTI/12/13/000001
-----------------------------------------------------------------------------
i want excel to generate the last cell "code" by Excel.
i understand that i will need to create libraries for courses and Centers to convert
into Course Code and center codes.
what should do? design something via visual basic?
i do not know how to use visual basic and not much knowldge of formulas in Excel
or is it getting more complex? do i need to use some other software or some program is needed to programmed.
microsoft Access and SQL express of any use?
ray2: hope to get replies soon
-------------------------------------------------------------------------
formula needed for creating Student ID
Student ID looks like-
CC1/ACTI/12/13/000001
defination-
*Code *legend (Example of data in Cell) Range of data
--------------------------------------------------------------------------
CC1 - Course code - (basic computer Course) Around 50 Courses
ACTI- Center Code - (Alma Computer Training Institute) Around 10 Centers
12 - month code - (December) 12 Month
13 - Year Code - (2013) 2013-2099
000001 - Sr. No. - (1) numerical value 1-999999
------------------------------------------------------------------------
i have course codes as CC1 for Basic Computer Course , for all 50 Courses.
i have Centers Codes as ACTI for Alma Computer tra..., for all centers
month,year and sr. no. (serial number range given above)
i want that Excel should extract code from data in the cells.
Example-
----------------------------------------------------------------------------
Sr. Center name Course Date of Enrol. Code
----------------------------------------------------------------------------
1 ACTI Suraj BAsic Computer Course 31/12/13 CC1/ACTI/12/13/000001
-----------------------------------------------------------------------------
i want excel to generate the last cell "code" by Excel.
i understand that i will need to create libraries for courses and Centers to convert
into Course Code and center codes.
what should do? design something via visual basic?
i do not know how to use visual basic and not much knowldge of formulas in Excel
or is it getting more complex? do i need to use some other software or some program is needed to programmed.
microsoft Access and SQL express of any use?
ray2: hope to get replies soon