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 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
