셀값을 구분자 기준, 여러셀에 나누기; Split(vba함수) 이용, 구글스프레드시트엔 이 함수가 있다
Synopsis
set c=ActiveCell:a=split(c,", "):c(2).resize(ubound(a)+1)=Application.Transpose(a) `슬기로운 직장생활을 위한 엑셀 써머리` ...
You Might Also Like
![[구글스프레드시트] 수식만으로 구분자를 기준으로 여러 행으로 나누기](https://i.ytimg.com/vi/uYbpwYwB1rQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAgEi5kkthUhMhdBjisKVLLyuJJuA)
![[구글스프레드시트] split함수 결과 중 3th 값들 가져오기](https://i.ytimg.com/vi/N5Nn852SGYk/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_AmAAtAFigIMCAAQARhlIGUoZTAP&rs=AOn4CLAmd9Z6GK66XYJXuje22UFce0Apzg)
![텍스트 분리하기(구글시트 SPLIT함수)[함수사용법]](https://i.ytimg.com/vi/H78yEe65JF8/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDbolw9Uq8njx6ZbwBHC3v0H2Yc0A)
![[구글스프레드시트] 여러 범위에 걸쳐 특정 구분자로 분리된 단어 개수 구하기 (Query, flatten,split,textjoin)](https://i.ytimg.com/vi/UVaLj4P54MY/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLC3Qs42f8c-v_VyjxMK5Z1v2D-_5A)
![[Excel 실무] TextSplit에서 여러 개의 구분자 사용하기](https://i.ytimg.com/vi/6JrGyavwFUI/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLANtpQM50fQqZmJ4sQtwoow0c5Tvg)
![[구글스프레드시트] 수식을 이용하여 일정한 간격으로 시간 배열 만들기](https://i.ytimg.com/vi/vp5YlqXZdxQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCw8R9d1oDSwNAuRIKQLD7EEI4O8Q)
![[UDF]한 셀을 개행 문자 기준으로 여러 행으로 분리하기(split, join 사용자 정의 함수)](https://i.ytimg.com/vi/p0EFYvPpKt0/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDxxWi-v9fJOp1Ivvy89YoWlqKGHw)
![[회세밥 VBA] 콤마기준 Split 하기](https://i.ytimg.com/vi/uBo3R_xtpTQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLD2g8T6vx5hQhpwZ2iC5IEOnsvZDA)
![[구글스프레드시트] REGEXEXTRACT 함수의 기본 이해와 패턴에 매칭되는 모든 값 가져오는 UDF](https://i.ytimg.com/vi/nOTzFs5Cv10/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_AmAAtAFigIMCAAQARhyIGIoGDAP&rs=AOn4CLBg7Qu4mLJJbyBxFpt7GLT5togikg)
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.