Automatically translated.View original post

SPLIT / TEXTSPLIT Comic Edition

2025/12/17 Edited to

... Read moreถ้าคุณกำลังค้นหา “split คือ” แบบอยากเอาไปใช้จริงกับงานตารางเลย สรุปง่ายๆ คือ SPLIT (ใน Google Sheets) และ TEXTSPLIT (ใน Excel) เป็นฟังก์ชันที่ “หั่นข้อความ” ในเซลล์เดียวออกเป็นหลายส่วน โดยอาศัย “ตัวคั่น” (delimiter) เช่น เครื่องหมายขีดกลาง (-) เว้นวรรค ช่องว่าง เครื่องหมายจุลภาค (, ) หรือสัญลักษณ์อื่นๆ ตัวอย่างที่เจอบ่อยมากในงานจริง คือข้อมูลวันที่ที่อยู่รวมกันแบบ 17-JUN-2023 แล้วอยากแยกเป็น 3 ช่อง: วัน / เดือน / ปี Google Sheets - สูตร: =SPLIT(A2,"-") - ความหมาย: เอาข้อความใน A2 ไปแยกโดยใช้ “-” เป็นตัวคั่น - ผลลัพธ์จะกระจาย (spill) ไปทางขวาอัตโนมัติ เช่น B2 = 17, C2 = JUN, D2 = 2023 Excel (Microsoft 365 / Excel รุ่นที่รองรับ Dynamic Array) - สูตร: =TEXTSPLIT(A2,"-") - หลักการเหมือนกัน คือแยกด้วยตัวคั่น “-” แล้วผลลัพธ์ไหลไปหลายคอลัมน์ ทริคที่ฉันใช้ประจำเวลา SPLIT ไม่ทำงาน 1) เช็กตัวคั่นให้ตรงกับข้อมูลจริง บางทีข้อมูลดูเหมือนมีขีดกลาง แต่จริงๆ เป็นคนละสัญลักษณ์ หรือมีเว้นวรรคแอบแทรก เช่น "17- JUN-2023" ถ้าเป็นแบบนี้ลองทำความสะอาดก่อน เช่น TRIM เพื่อตัดช่องว่างเกิน 2) ใส่เครื่องหมายคำพูดให้ถูก เวลาใช้ตัวคั่นเป็นตัวอักษรหรือสัญลักษณ์ ต้องใส่เป็นข้อความ เช่น "-" ไม่ใช่ - เฉยๆ 3) ถ้าไม่มีตัวคั่น จะ “หั่น” ไม่ได้ ข้อมูลอย่าง "JUN2025" ไม่มีสัญลักษณ์คั่น ฟังก์ชันจะไม่รู้จะแยกตรงไหน กรณีนี้ต้องเพิ่มรูปแบบให้มีตัวคั่นก่อน หรือใช้ฟังก์ชันคนละแบบ (เช่น LEFT/MID/RIGHT) ตามตำแหน่งตัวอักษร 4) ระวังพื้นที่ว่างด้านขวา SPLIT/TEXTSPLIT จะกระจายผลลัพธ์ไปหลายช่อง ถ้าช่องปลายทางมีข้อมูลอยู่แล้ว จะขึ้นข้อผิดพลาดหรือวางผลลัพธ์ไม่ได้ ให้เคลียร์เซลล์ด้านขวาก่อน ไอเดียการใช้งานที่ช่วยประหยัดเวลา - แยกชื่อ-นามสกุลจาก "ชื่อ นามสกุล" ด้วยตัวคั่นเป็นเว้นวรรค - แยกโค้ดสินค้าเช่น "ABC-001-TH" เป็น 3 ส่วน - แยกข้อมูลที่คั่นด้วยคอมมา เช่น รายการแท็ก "excel,data,report" ถ้าคุณลองแล้วติดตรงตัวคั่นไม่เหมือนกันทุกแถว แนะนำให้ดูแพตเทิร์นของข้อมูลก่อน แล้วค่อยเลือกวิธีหั่นที่เหมาะที่สุด จะช่วยลดการแก้สูตรวนไปมาได้เยอะเลย

Related posts

That DC Harley Quinn comic 😭
Also yes, I know the writer is a woman, this is a reference to Bruce Timm #dccomics #harleyquinn #booktok
Janzellll

Janzellll

92 likes

A screenshot of a text message from a boyfriend saying, 'I love our love story 🥰'. A menu for reply, add sticker, copy, translate, and more options is overlaid. The image also has text 'word of affirmation Text from my boyfriend'.
A screenshot of a text message from a boyfriend saying, 'I love you so much and I haven't stopped thinking about you all day'. A menu for reply, add sticker, copy, translate, and more options is overlaid.
A screenshot of a text message from a boyfriend saying, 'You're my home 🥰'. A menu for reply, add sticker, copy, translate, and more options is overlaid.
text that make me feel loved: boyfriend edition
i am so incredibly lucky to have a sweet boyfriend that understands my need for words of affirmation!! he’s the best and i love receiving sweet text like these. what’s your love language? let me know down below ⬇️ #lemon8challenge #lovestory #boyfriend #wordsofaffirmation #lovelanguage #
ella 🪩🛼💐

ella 🪩🛼💐

368 likes

The cover of The Amazing Spider-Man #320, featuring Spider-Man swinging and a character called Paladin in purple armor holding a gun, part of "The Assassin Nation Plot."
An advertisement for bicycles, showing a person performing a trick on a BMX bike, with text about racing and freestyle bicycles.
A comic book spread showing an advertisement for acne treatment pads on the left, and a panel from "The Amazing Spider-Man" comic on the right.
The Amazing Spider-man #320 Direct Edition
The Amazing Spider-man 320 Direct Edition Marvel Comic Book $8 #marvel #comics #comicbooks #spiderman #hero
Kevin's Comics

Kevin's Comics

23 likes

The Marvel Holiday Special 1994 comic cover features Spider-Man in a Santa hat on a Spider-Man mask, surrounded by a Christmas wreath. Ornaments show Captain America, Wolverine, and other characters. The Thing's head is on a red bow. It is a Direct Edition comic.
Marvel Holiday Special 1994 Direct Edition Comic
Marvel Holiday Special 1994 Direct Edition Comic Book #marvel #comicbooks #spiderman #wolverine #captainamerica
Kevin's Comics

Kevin's Comics

6 likes

The Amazing Spider-man #322 Direct Edition $10
The Amazing Spider-man 322 Direct Edition Marvel Comic Book $10 #marvel #comics #comicbooks #spiderman #hero
Kevin's Comics

Kevin's Comics

23 likes

a few comic books
#lemon8diarychallenge #comicbooks
Blaze🌬️

Blaze🌬️

20 likes

An exterior view of the Gaslamp Quarter entrance, decorated with Comic Con banners featuring SpongeBob SquarePants, with many people walking on the street under a clear sky.
A hand holds a small orange ticket with a smiley face, with a crowd of people and a 'BoxLunch' food truck visible in the background under a clear blue sky.
An indoor display at Comic Con featuring large anime-style character banners, including one with a character holding a cocktail, and a blue spiky beanbag chair in the foreground.
Day 19 of 21 Comic Con Edition
Dear Diary, I forgot to write yesterday but I'm just gonna write yesterday's events for today. I went to Comic Con again this year. Unfortunately, I didn't get tickets for the inside stuff, but they always have outside activities that are free, and they have goodies that they give
CherryCrochet

CherryCrochet

2 likes

The cover of The Amazing Spider-Man #323, featuring Captain America holding his shield while Spider-Man is entangled in chains below him. The title "THE ASSASSIN NATION PLOT" is visible at the top.
A full view of The Amazing Spider-Man #323 comic book cover, showing Captain America and Spider-Man. The comic is titled "THE ASSASSIN NATION PLOT PART FOUR OF SIX" and indicates it's on sale twice a month.
An advertisement for "Monstrous Compendiums" for a fantasy role-playing game, featuring illustrations of various monsters like dragons, trolls, and skeletal warriors, along with images of three book volumes.
The Amazing Spider-man #323 Direct Edition $20
The Amazing Spider-man 323 Direct Edition Marvel Comic Book in Very Good Condition $20 #marvel #comics #comicbooks #spiderman #hero
Kevin's Comics

Kevin's Comics

17 likes

Comic Book Pick-Ups 3-12-25
#marvelcomics #imagecomics #spiderman
Reaper 205

Reaper 205

38 likes

The Amazing Spider-man #319 Direct Edition $10
The Amazing Spider-man 319 Direct Edition Marvel Comic Book #marvel #comics #comicbooks #spiderman #hero
Kevin's Comics

Kevin's Comics

19 likes

The Amazing Spider-man #303 Direct Edition Marvel
The Amazing Spider-man 303 Direct Edition Marvel Comic Book in Great Condition Bagged and Boarded #spiderman #marvel #comics #comicbooks #hero
Kevin's Comics

Kevin's Comics

14 likes

A Discord server interface for 'The Comic Corner,' displaying a search bar, text channels including 'rules-and-guidelines,' 'general,' 'intro-to-comics,' 'ncbd,' 'iso,' and 'promote-your-content,' and a voice channel named 'General.'
New Discord Server for Comic readers!
What's up, everyone! I want to build a comic book community for newcomers and long-time enthusiasts alike. I made this new Discord Server in hopes of meeting new people and making a community that enjoys all things comic book related. If you're interested and would like to join, click that
Reaper 205

Reaper 205

1 like

The Amazing Spiderman #245 Newstand Edition Marvel
The Amazing Spiderman 245 Newstand Edition Marvel Comic Book #spiderman #marvel #comics #comicbooks #amazing
Kevin's Comics

Kevin's Comics

15 likes

Web of Spider-Man #90, a 30th Anniversary Special, features a holographic cover with Spider-Man's face. The issue highlights Spider-Man being haunted by his past and menaced by a villain, plus a bonus gatefold poster.
Web of Spider-Man #94 cover shows Spider-Man battling Hobgoblin, with text indicating "Hobgoblin Reborn Part Two." Guest appearances by Moon Knight, Ghost Rider's Hag and Troll, and Venom are also noted.
Web of Spider-Man #95, titled "Spirits of Venom Part 1," depicts Spider-Man, Venom, and Ghost Rider (Johnny Blaze) on a motorcycle. The cover emphasizes the presence of Venom, Ghost Rider, and Johnny Blaze.
Web of Spider-Man #90-128 Marvel Comic Books
Web of Spider-Man 90 -128 Marvel Comic Books All in great condition bagged and boarded #spiderman #web #comics #marvel #comicbooks
Kevin's Comics

Kevin's Comics

14 likes

The cover of X-Force #44 features Cable standing prominently in the foreground with a backpack, while other X-Force members like Shatterstar, Cannonball, and Siryn are grouped behind him against a green background. The title 'X-FORCE' is large and yellow.
The cover of X-Factor #113 shows a green-skinned character holding a blonde, muscular man in a fiery background. The text reads 'SHE'S EVIL... SHE'S DEADLY... SHE'S FATALE!' The title 'X-FACTOR' is at the top.
The cover of X-Factor #112 depicts a character with blonde hair and a blue costume clutching their head in distress, set against a black background with swirling white lines and a red lower section. The title 'X-FACTOR' is prominent.
6 Marvel Comic Books
X factor 97, 112, 113 X-Force 44 Excalibur 110 Prof. X and the X-Men 1 #comics #comicbooks #xmen #xforce #xfactor
Kevin's Comics

Kevin's Comics

16 likes

Wolverine #39 Inferno of Death Marvel Comic Book
Wolverine 39 Inferno of Death Marvel Comic Book Newstand Edition 1991 #wolverine #marvel #storm #comics #comicbooks
Kevin's Comics

Kevin's Comics

9 likes

Welcome to AI Makes My Life Easier — Text Edition!
Welcome to AI Makes My Life Easier — Text Edition! As a professional, I know the value of content that feels human, and is completely error-free. That’s where AI-to-human text converters come in! These tools help refine AI-generated content to make it sound more natural and relatable while pr
NeLo

NeLo

10 likes

Today’s Comic Haul 🦸🏻‍♀️
Andddddddd another one 🤷🏻‍♀️ (you’ll never guess the last comic series 🙄🤣) #booktok #bookhaul #fyp #comics #books🫶🏼
rhiley

rhiley

3 likes

Massive Marvel Comic Book legends!
Massive Marvel Comic Book legends! These giant-sized comic figures are larger than life and full of old-school comic charm. These straight out of the comics and super-sized for collectors! These giant Marvel figures are pure nostalgia.
Nerdmazing Toy Reviews

Nerdmazing Toy Reviews

6 likes

The cover of Wolverine #43 features a red, hulking Wolverine kneeling in water, with a zombie-like figure standing on his shoulders, raising a broken sword. The cover includes 'Marvel Comics', '$1.75 US', 'Issue 43', and a '50 Years A Captain America' emblem.
Wolverine #43 Direct Edition Marvel Comic Book
Wolverine 43 Direct Edition Marvel Comic Book #wolverine #marvel #comics #comicbooks #xmen
Kevin's Comics

Kevin's Comics

6 likes

The Amazing Spider-man #318 Direct Edition $10
The Amazing Spider-man 318 Direct Edition Marvel Comic Book in Great Condition Bagged and boarded. for sale $10 #marvel #comics #comicbooks #spiderman #hero
Kevin's Comics

Kevin's Comics

20 likes

Western Comics @ Jay’s| Local Comic Store
Pay day came. Covers be looking SO GOOD I forget what I came in for🤣 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 💭What’s your favorite comic book hero/anti-hero/villain and why?🤔 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #comics #DC #MARVEL #aethestic #lemon8
Lilac Mouse 🐁

Lilac Mouse 🐁

3 likes

The cover of Wolverine #1 Facsimile Edition comic book features Wolverine in a torn blue outfit, claws extended, standing triumphantly on a pile of defeated enemies under a full moon. The title 'WOLVERINE' is prominent, with 'MARVEL' and issue details like '$4.99' and '1 NOV' visible.
Wolverine #1 Facsimile Edition Marvel Comic Book
Wolverine #1 Facsimile Edition Marvel Comic Book #wolverine #marvel #comics #comicbooks #facsimile
Kevin's Comics

Kevin's Comics

8 likes

Saturday edition
Todays day #trending #splitfiction #lifestyle #dayinmylife
kelseak

kelseak

6 likes

The cover of Scarlet Spider #1 features Scarlet Spider (Ben Reilly) in his blue hoodie and red suit, holding a rope. A shadowy figure with glasses is in the background. Text includes "THERE'S A NEW WEB-SLINGER IN TOWN!" and "VIRTUAL MORTALITY PART 3 OF 4".
Scarlet Spider #1,2 Direct Edition Comic Books
Scarlet Spider #1 ,2 Direct Edition Comic Books #comics #comicbooks #marvel #scarletspider #spiderman
Kevin's Comics

Kevin's Comics

15 likes

A collection of various Marvel and DC comic books, including Absolute Superman, Giant-Size X-Men, Wiccan Witches' Road, X-Men Forever, Ultimate X-Men, and Red Hood Outlaw, displayed on a pink fabric surface.
A Marvel comic book titled 'Wiccan Witches' Road #1' featuring two male characters, one with dark hair and one with green skin, holding hands in a dark, mystical forest setting.
A Marvel comic book titled 'Wiccan Witches' Road #2 Variant Edition' with cover art showing two male characters, one with dark hair and one with green skin, looking at each other in a dark, magical environment.
Comic haul! 💥
Super excited for all of these! (Already caught up with Absolute Flash, just collecting what I’ve read digitally) #comicbooks #comics #bookhaul #dccomics #marvelcomics
rhiley

rhiley

23 likes

ASM #361 (2nd Edition) Grey Background Key Issue
(2nd Edition)The Amazing Spider-man 361 Key Issue (Grey Background) Marvel Comic Book in Great Condition #spiderman #venom #marvel #carnage #comics
Kevin's Comics

Kevin's Comics

35 likes

Comic merch in my nerd room 💥
DC, Marvel, and Invincible merch that isn’t on my shelves 💫 #dccomics #marvelcomics #collectorvibes #nerd #roomtour
rhiley

rhiley

16 likes

X-Men Unlimited #1-8 Marvel Comic Books
X-Men Unlimited 1 -8 Marvel Comic Books For sale at my eBay store @kevcsawy #marvel #comics #comicbooks #xmen #heroes
Kevin's Comics

Kevin's Comics

15 likes

A woman with dark hair in a bun, wearing a white tank top and large hoop earrings that say "Bonita." Text overlay reads "CONTENT IDEAS + HOOKS For My Latinas Baddies." The Lemon8 logo and username are at the bottom.
A list of content ideas for Latinas, including themes like coffee rituals, self-care, confidence, and cultural pride. Each idea is accompanied by a brief description of the suggested content format. The Lemon8 logo is at the bottom.
A continuation of content ideas for Latinas, featuring themes such as building a dream life, overcoming struggles, setting boundaries, and celebrating cultural identity. Each idea includes a short description of the suggested content. The Lemon8 logo is at the bottom.
Content Ideas Latina Edition 🌸
Save for your next content batch day! #contentcreatoridea #latinacontent #latinacontentcreator #socialmediamanager #socialmediacontentcreator
Eunice

Eunice

4 likes

An overhead shot of several Marvel X-Men comic books spread out on a wooden floor, with a text overlay stating 'What I got in an X-MEN Comic mystery pack'.
A close-up of a Marvel X-Men comic book, issue #36, featuring Sabretooth and a character in red and yellow armor, with the title 'Phalanx Covenant'.
A close-up of a Marvel Excalibur comic book, issue #108, titled 'It Begins Here! Battle Over Britain!', depicting several characters in a dynamic battle scene.
Comic Mystery Pack!!!
#comics #comicbookfans #comiccollector #xmen #xmencomics
Cassidy

Cassidy

8 likes

See more