엑셀 텍스트 함수 10강] Left 함수와 텍스트 나누기 기능을 사용하여 주민번호로 생년월일 구하기
Synopsis
실습 데이터 다운로드 → http://hantip.net/221 강좌가 도움이 되셨다면 구독과 좋아요! 버튼을 눌러주세요. 업데이트 되는 새로운 강좌 ...
You Might Also Like
![엑셀 텍스트 함수 11강] LEN, FIND 함수와 유효성 검사로 주민등록번호 입력 제한하기](https://i.ytimg.com/vi/pTfEEMiCk6Q/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDvA-7dPpohg671tRSX5nauSv0SPA)
![[엑셀함수] 주민번호에서 성별,생년월일 계산하기](https://i.ytimg.com/vi/oodMS9rGSRk/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBcSqRruzLFoaNKCbRXmyk98QJwkg)
![[Excel Text Functions Lesson 1] Extracting Text Using the LEFT, RIGHT, and MID Functions (Subtitles)](https://i.ytimg.com/vi/rYXqhppvQrY/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDk7KamDKtSoQK3_o-g_CLIUOPKwg)
![[엑셀을 부탁해] 날짜 및 텍스트 함수를 살펴보고 생년월일구하기](https://i.ytimg.com/vi/TdbINFl50GE/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCdqH1m7fFaImvAunFgT8D2mBFnFA)
![Excel Date and Time Functions Lesson 4] Finding Date of Birth from Resident Registration Number U...](https://i.ytimg.com/vi/QGwY5NdUPOw/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAhX63oQfigsSaRRrgr0yk409a-2g)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.