RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
Posted by tenn
,

[Excel][Tip] 셀참조

Excel 2008. 6. 12. 10:31
셀 참조 하려면

= [Cell number] & "String"

ex)   = G35 & "입니다."






http://cafe.naver.com/akadream.cafe
전체공개 2007.07.19 13:25
Posted by tenn
,
Date d = new Date();
new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(d);


쓰려고 하면 맨날 까먹는.
Posted by tenn
,