creating code from text in cells

[abhiflexy]

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?

hope to get replies soon

[TMS]

Maybe something like the following UDF:

Please Login or Register  to view this content.

Called like:

Please Login or Register  to view this content.

Regards, TMS