[질문] 한글이름 영어로 변환시키기

[별에못을박다]

안녕 하세요^^

한글이름을 영어로 변환 함 시켜 볼려구 하는데 잘 되지

않네요

고수님들의 답변이나 한수 배워 봅니다.

첨부처럼 시트2에다 밑에 적어 놓은 걸 입력하구

첨부처럼 이름 성 쓰면 자동 변환 하게 될수 있을까요?

new Array("가","GA"),
new Array("각","GAK"),
new Array("간","GAN"),
new Array("갈","GAL"),
new Array("감","GAM"),
new Array("갑","GAP"),
new Array("갓","GAT"),
new Array("강","GANG"),
new Array("개","GAE"),
new Array("객","GAEK"),
new Array("거","GEO"),
new Array("건","GEON"),
new Array("걸","GEOL"),
new Array("검","GUM"),
new Array("겁","GUP"),
new Array("게","GE"),
new Array("겨","GYEO"),
new Array("격","GYEOK"),
new Array("견","GYEON"),
new Array("결","GYEOL"),
new Array("겸","GYEOM"),
new Array("겹","GYEOP"),
new Array("경","GYUNG"),
new Array("계","GYE"),
new Array("고","GO"),
new Array("곡","GOK"),
new Array("곤","GON"),
new Array("골","GOL"),
new Array("곳","GOT"),
new Array("공","GONG"),
new Array("곶","GOT"),
new Array("과","GWA"),
new Array("곽","GWAK"),
new Array("관","GWAN"),
new Array("괄","GWAL"),
new Array("광","GWANG"),
new Array("괘","GWAE"),
new Array("괴","GOE"),
new Array("굉","GOENG"),
new Array("교","GYO"),
new Array("구","GOO"),
new Array("국","GUK"),
new Array("군","GUN"),
new Array("굴","GUL"),
new Array("굿","GUT"),
new Array("궁","GUNG"),
new Array("권","GWON"),
new Array("궐","GWOL"),
new Array("궤","GWE"),
new Array("귀","GWI"),
new Array("규","GYOO"),
new Array("균","GYOON"),
new Array("귤","GYOOL"),
new Array("그","GEU"),
new Array("극","GEUK"),
new Array("근","GEUN"),
new Array("글","GEUL"),
new Array("금","GEUM"),
new Array("급","GEUP"),
new Array("긍","GEUNG"),
new Array("기","GI"),
new Array("긴","GIN"),
new Array("길","GIL"),
new Array("김","GIM"),
new Array("까","KKA"),
new Array("깨","KKAE"),
new Array("꼬","KKO"),
new Array("꼭","KKOK"),
new Array("꽃","KKOT"),
new Array("꾀","KKOE"),
new Array("꾸","KKU"),
new Array("꿈","KKUM"),
new Array("끝","KKEUT"),
new Array("끼","KKI"),
new Array("나","NA"),
new Array("낙","NAK"),
new Array("난","NAN"),
new Array("날","NAL"),
new Array("남","NAM"),
new Array("납","NAP"),
new Array("낭","NANG"),
new Array("내","NAE"),
new Array("냉","NAENG"),
new Array("너","NEO"),
new Array("널","NEOL"),
new Array("네","NE"),
new Array("녀","NYEO"),
new Array("녁","NYEOK"),
new Array("년","NYEON"),
new Array("념","NYEOM"),
new Array("녕","NYUNG"),
new Array("노","NO"),
new Array("녹","NOK"),
new Array("논","NON"),
new Array("놀","NOL"),
new Array("농","NONG"),
new Array("뇌","NOE"),
new Array("누","NU"),
new Array("눈","NUN"),
new Array("눌","NUL"),
new Array("느","NEU"),
new Array("늑","NEUK"),
new Array("늠","NEUM"),
new Array("능","NEUNG"),
new Array("늬","NUI"),
new Array("니","NEE"),
new Array("닉","NIK"),
new Array("닌","NIN"),
new Array("닐","NIL"),
new Array("님","NIM"),
new Array("다","DA"),
new Array("단","DAN"),
new Array("달","DAL"),
new Array("담","DAM"),
new Array("답","DAP"),
new Array("당","DANG"),
new Array("대","DAE"),
new Array("댁","DAEK"),
new Array("더","DEO"),
new Array("덕","DEOK"),
new Array("도","DO"),
new Array("독","DOK"),
new Array("돈","DON"),
new Array("돌","DOL"),
new Array("동","DONG"),
new Array("돼","DWAE"),
new Array("되","DOE"),
new Array("된","DOEN"),
new Array("두","DOO"),
new Array("둑","DOOK"),
new Array("둔","DOON"),
new Array("뒤","DWI"),
new Array("드","DEU"),
new Array("득","DEUK"),
new Array("들","DEUL"),
new Array("등","DEUNG"),
new Array("듸","DUI"),
new Array("디","DI"),
new Array("따","TTA"),
new Array("땅","TTANG"),
new Array("때","TTAE"),
new Array("또","TTO"),
new Array("뚜","TTU"),
new Array("뚝","TTUK"),
new Array("뜨","TTEU"),
new Array("띠","TTI"),
new Array("라","RA"),
new Array("락","RAK"),
new Array("란","RAN"),
new Array("람","RAM"),
new Array("랑","RANG"),
new Array("래","RAE"),
new Array("랭","RAENG"),
new Array("량","RYANG"),
new Array("렁","REONG"),
new Array("레","RE"),
new Array("려","RYEO"),
new Array("력","RYEOK"),
new Array("련","RYUN"),
new Array("렬","RYUL"),
new Array("렴","RYEOM"),
new Array("렵","RYEOP"),
new Array("령","RYUNG"),
new Array("례","RYE"),
new Array("로","RO"),
new Array("록","ROK"),
new Array("론","RON"),
new Array("롱","RONG"),
new Array("뢰","ROE"),
new Array("료","RYO"),
new Array("룡","RYONG"),
new Array("루","RU"),
new Array("류","RYU"),
new Array("륙","RYUK"),
new Array("륜","RYUN"),
new Array("률","RYUL"),
new Array("륭","RYUNG"),
new Array("르","REU"),
new Array("륵","REUK"),
new Array("른","REUN"),
new Array("름","REUM"),
new Array("릉","REUNG"),
new Array("리","REE"),
new Array("린","RIN"),
new Array("림","RIM"),
new Array("립","RIP"),
new Array("마","MA"),
new Array("막","MAK"),
new Array("만","MAN"),
new Array("말","MAL"),
new Array("망","MANG"),
new Array("매","MAE"),
new Array("맥","MAEK"),
new Array("맨","MAEN"),
new Array("맹","MAENG"),
new Array("머","MEO"),
new Array("먹","MEOK"),
new Array("메","ME"),
new Array("며","MYEO"),
new Array("멱","MYEOK"),
new Array("면","MYEON"),
new Array("멸","MYEOL"),
new Array("명","MYUNG"),
new Array("모","MO"),
new Array("목","MOK"),
new Array("몰","MOL"),
new Array("못","MOT"),
new Array("몽","MONG"),
new Array("뫼","MOE"),
new Array("묘","MYO"),
new Array("무","MOO"),
new Array("묵","MOOK"),
new Array("문","MOON"),
new Array("물","MOOL"),
new Array("므","MEU"),
new Array("미","MEE"),
new Array("민","MIN"),
new Array("밀","MIL"),
new Array("바","BA"),
new Array("박","BAK"),
new Array("반","BAN"),
new Array("발","BAL"),
new Array("밥","BAP"),
new Array("방","BANG"),
new Array("배","BAE"),
new Array("백","BAEK"),
new Array("뱀","BAEM"),
new Array("버","BEO"),
new Array("번","BEON"),
new Array("벌","BEOL"),
new Array("범","BEOM"),
new Array("법","BEOP"),
new Array("벼","BYEO"),
new Array("벽","BYEOK"),
new Array("변","BYEON"),
new Array("별","BYUL"),
new Array("병","BYUNG"),
new Array("보","BO"),
new Array("복","BOK"),
new Array("본","BON"),
new Array("봉","BONG"),
new Array("부","BU"),
new Array("북","BUK"),
new Array("분","BUN"),
new Array("불","BUL"),
new Array("붕","BOONG"),
new Array("비","BEE"),
new Array("빈","BIN"),
new Array("빌","BIL"),
new Array("빔","BIM"),
new Array("빙","BING"),
new Array("빠","PPA"),
new Array("빼","PPAE"),
new Array("뻐","PPEO"),
new Array("뽀","PPO"),
new Array("뿌","PPU"),
new Array("쁘","PPEU"),
new Array("삐","PPI"),
new Array("사","SA"),
new Array("삭","SAK"),
new Array("산","SAN"),
new Array("살","SAL"),
new Array("삼","SAM"),
new Array("삽","SAP"),
new Array("상","SANG"),
new Array("샅","SAT"),
new Array("새","SAE"),
new Array("색","SAEK"),
new Array("생","SAENG"),
new Array("서","SEO"),
new Array("석","SEOK"),
new Array("선","SEON"),
new Array("설","SEOL"),
new Array("섬","SEOM"),
new Array("섭","SEOP"),
new Array("성","SEONG"),
new Array("세","SE"),
new Array("셔","SYEO"),
new Array("소","SO"),
new Array("속","SOK"),
new Array("손","SON"),
new Array("솔","SOL"),
new Array("솟","SOT"),
new Array("송","SONG"),
new Array("쇄","SWAE"),
new Array("쇠","SOE"),
new Array("수","SOO"),
new Array("숙","SOOK"),
new Array("순","SOON"),
new Array("술","SOOL"),
new Array("숨","SOOM"),
new Array("숭","SOONG"),
new Array("쉬","SWI"),
new Array("스","SEU"),
new Array("슬","SEUL"),
new Array("슴","SEUM"),
new Array("습","SEUP"),
new Array("승","SEUNG"),
new Array("시","SEE"),
new Array("식","SIK"),
new Array("신","SIN"),
new Array("실","SIL"),
new Array("심","SIM"),
new Array("십","SIP"),
new Array("싱","SING"),
new Array("싸","SSA"),
new Array("쌍","SSANG"),
new Array("쌔","SSAE"),
new Array("쏘","SSO"),
new Array("쑥","SSOOK"),
new Array("씨","SSI"),
new Array("아","A"),
new Array("악","AK"),
new Array("안","AN"),
new Array("알","AL"),
new Array("암","AM"),
new Array("압","AP"),
new Array("앙","ANG"),
new Array("앞","AP"),
new Array("애","AE"),
new Array("액","AEK"),
new Array("앵","AENG"),
new Array("야","YA"),
new Array("약","YAK"),
new Array("얀","YAN"),
new Array("양","YANG"),
new Array("어","EO"),
new Array("억","EOK"),
new Array("언","EON"),
new Array("얼","EOL"),
new Array("엄","EOM"),
new Array("업","EOP"),
new Array("에","E"),
new Array("여","YEO"),
new Array("역","YEOK"),
new Array("연","YUN"),
new Array("열","YEOL"),
new Array("염","YEOM"),
new Array("엽","YEOP"),
new Array("영","YOUNG"),
new Array("예","YE"),
new Array("오","OH"),
new Array("옥","OCK"),
new Array("온","ON"),
new Array("올","OL"),
new Array("옴","OM"),
new Array("옹","ONG"),
new Array("와","WA"),
new Array("완","WAN"),
new Array("왈","WAL"),
new Array("왕","WANG"),
new Array("왜","WAE"),
new Array("외","OE"),
new Array("왼","OEN"),
new Array("요","YO"),
new Array("욕","YOK"),
new Array("용","YONG"),
new Array("우","WOO"),
new Array("욱","WOOK"),
new Array("운","WOON"),
new Array("울","WOOL"),
new Array("움","WOOM"),
new Array("웅","WOONG"),
new Array("워","WO"),
new Array("원","WON"),
new Array("월","WOL"),
new Array("위","WI"),
new Array("유","YOO"),
new Array("육","YOOK"),
new Array("윤","YOON"),
new Array("율","YOOL"),
new Array("융","YOONG"),
new Array("윷","YOOT"),
new Array("으","EU"),
new Array("은","EUN"),
new Array("을","EUL"),
new Array("음","EUM"),
new Array("읍","EUP"),
new Array("응","EUNG"),
new Array("의","UI"),
new Array("이","EE"),
new Array("익","IK"),
new Array("인","IN"),
new Array("일","IL"),
new Array("임","IM"),
new Array("입","IP"),
new Array("잉","ING"),
new Array("자","JA"),
new Array("작","JAK"),
new Array("잔","JAN"),
new Array("잠","JAM"),
new Array("잡","JAP"),
new Array("장","JANG"),
new Array("재","JAE"),
new Array("쟁","JAENG"),
new Array("저","JEO"),
new Array("적","JUK"),
new Array("전","JUN"),
new Array("절","JUL"),
new Array("점","JUM"),
new Array("접","JUP"),
new Array("정","JUNG"),
new Array("제","JE"),
new Array("조","JO"),
new Array("족","JOK"),
new Array("존","JON"),
new Array("졸","JOL"),
new Array("종","JONG"),
new Array("좌","JWA"),
new Array("죄","JOE"),
new Array("주","JU"),
new Array("죽","JOOK"),
new Array("준","JOON"),
new Array("줄","JOOL"),
new Array("중","JOONG"),
new Array("쥐","JWI"),
new Array("즈","JEU"),
new Array("즉","JEUK"),
new Array("즐","JEUL"),
new Array("즘","JEUM"),
new Array("즙","JEUP"),
new Array("증","JEUNG"),
new Array("지","JI"),
new Array("직","JIK"),
new Array("진","JIN"),
new Array("질","JIL"),
new Array("짐","JIM"),
new Array("집","JIP"),
new Array("징","JING"),
new Array("짜","JJA"),
new Array("째","JJAE"),
new Array("쪼","JJO"),
new Array("찌","JJI"),
new Array("차","CHA"),
new Array("착","CHAK"),
new Array("찬","CHAN"),
new Array("찰","CHAL"),
new Array("참","CHAM"),
new Array("창","CHANG"),
new Array("채","CHAE"),
new Array("책","CHAEK"),
new Array("처","CHEO"),
new Array("척","CHEOK"),
new Array("천","CHUN"),
new Array("철","CHUL"),
new Array("첨","CHEOM"),
new Array("첩","CHEOP"),
new Array("청","CHUNG"),
new Array("체","CHE"),
new Array("초","CHO"),
new Array("촉","CHOK"),
new Array("촌","CHON"),
new Array("총","CHONG"),
new Array("최","CHOE"),
new Array("추","CHOO"),
new Array("축","CHOOK"),
new Array("춘","CHOON"),
new Array("출","CHOOL"),
new Array("춤","CHOOM"),
new Array("충","CHOONG"),
new Array("측","CHEUK"),
new Array("층","CHEUNG"),
new Array("치","CHEE"),
new Array("칙","CHIK"),
new Array("친","CHIN"),
new Array("칠","CHIL"),
new Array("침","CHIM"),
new Array("칩","CHIP"),
new Array("칭","CHING"),
new Array("칩","CHIP"),
new Array("칭","CHING"),
new Array("코","KO"),
new Array("쾌","KWAE"),
new Array("크","KEU"),
new Array("큰","KEUN"),
new Array("키","KEE"),
new Array("타","TA"),
new Array("탁","TAK"),
new Array("탄","TAN"),
new Array("탈","TAL"),
new Array("탐","TAM"),
new Array("탑","TAP"),
new Array("탕","TANG"),
new Array("태","TAE"),
new Array("택","TAEK"),
new Array("탱","TAENG"),
new Array("터","TEO"),
new Array("테","TE"),
new Array("토","TO"),
new Array("톤","TON"),
new Array("톨","TOL"),
new Array("통","TONG"),
new Array("퇴","TOE"),
new Array("투","TOO"),
new Array("퉁","TOONG"),
new Array("튀","TWI"),
new Array("트","TEU"),
new Array("특","TEUK"),
new Array("틈","TEUM"),
new Array("티","TEE"),
new Array("파","PA"),
new Array("판","PAN"),
new Array("팔","PAL"),
new Array("패","PAE"),
new Array("팽","PAENG"),
new Array("퍼","PEO"),
new Array("페","PE"),
new Array("펴","PYEO"),
new Array("편","PYUN"),
new Array("폄","PYUM"),
new Array("평","PYUNG"),
new Array("폐","PYE"),
new Array("포","PO"),
new Array("폭","POK"),
new Array("표","PYO"),
new Array("푸","POO"),
new Array("품","POOM"),
new Array("풍","POONG"),
new Array("프","PEU"),
new Array("피","PEE"),
new Array("픽","PIK"),
new Array("필","PIL"),
new Array("핍","PIP"),
new Array("하","HA"),
new Array("학","HAK"),
new Array("한","HAN"),
new Array("할","HAL"),
new Array("함","HAM"),
new Array("합","HAP"),
new Array("항","HANG"),
new Array("해","HAE"),
new Array("핵","HAEK"),
new Array("행","HAENG"),
new Array("향","HYANG"),
new Array("허","HEO"),
new Array("헌","HUN"),
new Array("험","HUM"),
new Array("헤","HE"),
new Array("혀","HYEO"),
new Array("혁","HYUK"),
new Array("현","HYUN"),
new Array("혈","HYUL"),
new Array("혐","HYUM"),
new Array("협","HYUP"),
new Array("형","HYUNG"),
new Array("혜","HYE"),
new Array("호","HO"),
new Array("혹","HOK"),
new Array("혼","HON"),
new Array("홀","HOL"),
new Array("홉","HOP"),
new Array("홍","HONG"),
new Array("화","HWA"),
new Array("확","HWAK"),
new Array("환","HWAN"),
new Array("활","HWAL"),
new Array("황","HWANG"),
new Array("홰","HWAE"),
new Array("횃","HWAET"),
new Array("회","HOE"),
new Array("획","HOEK"),
new Array("횡","HOENG"),
new Array("효","HYO"),
new Array("후","HOO"),
new Array("훈","HOON"),
new Array("훤","HWON"),
new Array("훼","HWE"),
new Array("휘","HWI"),
new Array("휴","HYOO"),
new Array("휼","HYUL"),
new Array("흉","HYUNG"),
new Array("흐","HEU"),
new Array("흑","HEUK"),
new Array("흔","HEUN"),
new Array("흘","HEUL"),
new Array("흠","HEUM"),
new Array("흡","HEUP"),
new Array("흥","HEUNG"),
new Array("희","HEE"),
new Array("흰","HUIN"),
new Array("히","HI"),
new Array("힘","HIM")
)

var first_name = new Array(
new Array("김","KIM"),
new Array("이","LEE"),
new Array("박","PARK"),
new Array("최","CHOI"),
new Array("정","JEONG"),
new Array("강","KANG"),
new Array("조","CHO"),
new Array("윤","YOON"),
new Array("장","JANG"),
new Array("임","LIM"),
new Array("한","HAN"),
new Array("신","SHIN"),
new Array("오","OH"),
new Array("서","SEO"),
new Array("권","KWON"),
new Array("황","HWANG"),
new Array("송","SONG"),
new Array("안","AHN"),
new Array("유","YOO"),
new Array("류","RYOO"),
new Array("홍","HONG"),
new Array("전","JUN"),
new Array("고","GOH"),
new Array("문","MOON"),
new Array("손","SHON"),
new Array("양","YANG"),
new Array("배","BAE"),
new Array("백","BAEK"),
new Array("허","HEO"),
new Array("남","NAM"),
new Array("심","SHIM"),
new Array("노","NOH"),
new Array("하","HA"),
new Array("성","SUNG"),
new Array("곽","KWAK"),
new Array("차","CHA"),
new Array("구","GOO"),
new Array("우","WOO"),
new Array("주","JOO"),
new Array("나","NA"),
new Array("민","MIN"),
new Array("지","JI"),
new Array("진","JIN"),
new Array("엄","UHM"),
new Array("원","WON"),
new Array("채","CHAE"),
new Array("천","CHEON"),
new Array("방","BANG"),
new Array("공","GONG"),
new Array("현","HYEON"),
new Array("함","HAM"),
new Array("변","BYEON"),
new Array("염","YEOM"),
new Array("여","YEO"),
new Array("연","YEON"),
new Array("추","CHOO"),
new Array("도","DO"),
new Array("석","SEOK"),
new Array("소","SOH"),
new Array("설","SEOL"),
new Array("선","SUN"),
new Array("주","JOO"),
new Array("길","GIL"),
new Array("마","MA"),
new Array("표","PYO"),
new Array("위","WI"),
new Array("명","MYUNG"),
new Array("기","GI"),
new Array("반","BAN"),
new Array("왕","WANG"),
new Array("금","GEUM"),
new Array("옥","OAK"),
new Array("육","YOOK"),
new Array("인","IN"),
new Array("맹","MAENG"),
new Array("제","JE"),
new Array("탁","TAK"),
new Array("남궁","NAMGGOONG"),
new Array("모","MO"),
new Array("국","KOOK"),
new Array("어","EO"),
new Array("은","EUN"),
new Array("편","PYEON"),
new Array("용","YONG"),
new Array("예","YE"),
new Array("봉","BONG"),
new Array("경","KYEONG"),
new Array("사","SA"),
new Array("부","BOO"),
new Array("황보","HWANGBO"),
new Array("가","GA"),
new Array("태","TAE"),
new Array("복","BOK"),
new Array("목","MOK"),
new Array("계","KYE"),
new Array("피","PI"),
new Array("형","HYEONG"),
new Array("두","DOO"),
new Array("감","GAM"),
new Array("동","DONG"),
new Array("음","EUM"),
new Array("온","OHN"),
new Array("제갈","JEGAL"),
new Array("사공","SAGONG"),
new Array("호","HO"),
new Array("좌","JWA"),
new Array("선우","SEONWOO"),
new Array("갈","GAL"),
new Array("범","BEOM"),
new Array("빈","BIN"),
new Array("팽","PAENG"),
new Array("서문","SEOMOON"),
new Array("승","SEUNG"),
new Array("시","SI"),
new Array("상","SANG"),
new Array("간","GAN"),
new Array("화","HWA"),
new Array("단","DAN"),
new Array("견","KYEON"),
new Array("순","SOON"),
new Array("당","DANG"),
new Array("창","CHANG"),
new Array("독고","DOKGO"),
new Array("옹","ONG"),
new Array("평","PYEONG"),
new Array("종","JONG"),
new Array("섭","SEOB"),
new Array("묵","MOOK"),
new Array("궁","GOONG"),
new Array("대","DAE"),
new Array("빙","BING"),
new Array("근","KEUN"),
new Array("풍","POONG"),
new Array("영","YEONG"),
new Array("낭","NANG"),
new Array("아","AH"),
new Array("내","NAE"),
new Array("만","MAN"),
new Array("해","HAE"),
new Array("궉","KWOK"),
new Array("포","PO"),
new Array("판","PAN"),
new Array("초","CHO"),
new Array("매","MAE"),
new Array("군","GOON"),
new Array("요","YO"),
new Array("필","PIL"),
new Array("점","JEOM"),
new Array("곡","GOK"),
new Array("동방","DONGBANG"),
new Array("개","GAE"),
new Array("미","MI"),
new Array("준","JOON"),
new Array("수","SOO"),
new Array("야","YA"),
new Array("자","JA"),
new Array("운","WOON"),
new Array("뇌","NOI"),
new Array("돈","DON"),
new Array("탄","TAN"),
new Array("삼","SAM"),
new Array("애","AE"),
new Array("후","HOO"),
new Array("비","BI"),
new Array("난","NAN"),
new Array("묘","MYO"),
new Array("교","KYO"),
new Array("학","HAK"),
new Array("망절","MANGJEOL"),
new Array("십","SIB"),
new Array("흥","HEUNG"),
new Array("춘","CHUN"),
new Array("누","NOO"),
new Array("저","JEO"),
new Array("강전","KANGJEON"),
new Array("소봉","SOBONG"),
new Array("장곡","JANGGOK"),
new Array("즙","JEUP")

[엑셀배우는중]

이거 엑셀에서 배우는건가요? 단원이름이뭐죠