[구글스프레드시트] (split+regexreplace) 복수 개의 문자열을 구분자로 텍스트 나누기
Synopsis
split #regexreplace -------------------------------------------------------------------------------- 좋아요/구독 눌러주세요. 큰 힘이 됩니다.
![[구글스프레드시트] regexreplace를 이용한 일련번호 텍스트 나누기](https://i.ytimg.com/vi/6J2dZOVmeHQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAKll2Vk_NVctW4uBB2GXkU21kj0A)
![텍스트 분리하기(구글시트 SPLIT함수)[함수사용법]](https://i.ytimg.com/vi/H78yEe65JF8/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDbolw9Uq8njx6ZbwBHC3v0H2Yc0A)
![[구글스프레드시트] regexExtract, regexReplace를 이용하여 숫자만 가져오기](https://i.ytimg.com/vi/2ZbTTIuh2Jg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAPG95dZ3qZJ1VW__QbUVqAlW9tbg)
![[구글스프레드시트] 수식만으로 줄바꿈 문자(char(10))로 분리된 여러 셀을 하나의 데이타로 합치기](https://i.ytimg.com/vi/h5BeFUX_S2Q/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCPu_D7kb988MuaFde8AMjtOROFvg)
![[구글스프레드시트] 여러 범위에 걸쳐 특정 구분자로 분리된 단어 개수 구하기 (Query, flatten,split,textjoin)](https://i.ytimg.com/vi/UVaLj4P54MY/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLC3Qs42f8c-v_VyjxMK5Z1v2D-_5A)
![left함수 !! 필요한 텍스트만 추출해보자! 텍스트 추출 함수 [ 구글스프레드시트 엑셀 ]](https://i.ytimg.com/vi/I5QmHaeFs_I/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBnA1NuTNlU5L2X_vmm_4x_8Y2iCw)
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.