การค้นหาและคืนค่ามาหลายคอลัมภ์ใน Excel

<p> เราจะใช้คำสั่ง Vlookup ในการค้นหาข้อมูลใน Excel โดย Vlookup มีรูปแบบคำสั่งดังนี้</p><p>=VLOOKUP("lookup_value", lookup_range, {col1, col2, col3...}, [match])`¹ `</p><p>โดย   lookup_value` คือค่าที่คุณต้องการค้นหาในแนวตั้ง และ  `lookup_range` คือช่วงข้อมูลสำหรับค้นหา `lookup_value` และค่าที่ตรงกัน¹ </p><p>ตัวอย่างการใช้งาน</p><table style="background-color: rgba(255, 255, 255, 0.6); border-radius: var(--cib-border-radius-medium); border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; margin: 12px 0px 8px; overflow: hidden; padding: 0px 12px; table-layout: fixed; width: 736.008px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); line-height: var(--cib-type-body1-strong-line-height); overflow-wrap: break-word; padding-inline-start: 0px; padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Employee ID</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); line-height: var(--cib-type-body1-strong-line-height); overflow-wrap: break-word; padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Name</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); line-height: var(--cib-type-body1-strong-line-height); overflow-wrap: break-word; padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Department</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); line-height: var(--cib-type-body1-strong-line-height); overflow-wrap: break-word; padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Salary</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding-inline-start: 0px; padding: 8px 4px; vertical-align: baseline; word-break: initial;">1</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">John</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">Sales</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">5000</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding-inline-start: 0px; padding: 8px 4px; vertical-align: baseline; word-break: initial;">2</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">Jane</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">Marketing</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">6000</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding-inline-start: 0px; padding: 8px 4px; vertical-align: baseline; word-break: initial;">3</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">Bob</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">IT</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">7000</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding-inline-start: 0px; padding: 8px 4px; vertical-align: baseline; word-break: initial;">4</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">Lily</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">HR</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); overflow-wrap: break-word; padding: 8px 4px; vertical-align: baseline; word-break: initial;">8000</td></tr></tbody></table><p><br />จากตาราง ในเซลล์แรกของตารางใหม่ที่คุณต้องการแสดงชื่อ ให้ป้อนสูตร =VLOOKUP(A2,$A$2:$D$5,{2,3,4},FALSE) โดย</p><p>ที่ A2 คือเซลล์ที่มี รหัสพนักงานที่คุณต้องการค้นหา </p><p>$A$2:$D$5 คือช่วงของตารางข้อมูลพนักงาน </p><p>{2,3,4} หมายความว่าคุณต้องการคืนค่าจากคอลัมน์ 2 (ชื่อ), 3 (แผนก), และ 4 (เงินเดือน)</p><p> และ FALSE หมายความว่าคุณต้องการการจับคู่แบบตรงทั้งหมด</p><p>กด Enter เพื่อรับผลลัพธ์</p><p>ตัวอย่างเช่น ถ้าคุณป้อนรหัสพนักงาน 2 ในเซลล์ A2 สูตรจะส่งกลับ Jane, Marketing และ 6000 ในเซลล์ที่คุณป้อนสูตร</p><p><br /></p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="allowfullscreen" class="b-hbp-video b-uploaded" frameborder="0" height="266" id="BLOGGER-video-22eb9e6dc777123d-16672" mozallowfullscreen="mozallowfullscreen" src="https://www.blogger.com/video.g?token=AD6v5dx6JyAs7Dp2dgYCz-lXAbMSef6elRcSCpibL63EbMTWE_U1KRiG01KrsGa7uTXrixlAVoQSNcpmAoQYi_nxbuu387kEbIvy6qT31xODKJ5gkLSL4ZNa_VUhc9-6jxQ5MsEMwfGD" webkitallowfullscreen="webkitallowfullscreen" width="320"></iframe></div><br /><p><br /></p>

การค้นหาและคืนค่ามาหลายคอลัมภ์ใน Excel

 เราจะใช้คำสั่ง Vlookup ในการค้นหาข้อมูลใน Excel โดย Vlookup มีรูปแบบคำสั่งดังนี้ =VLOOKUP("lookup_value", lookup_range, {col1, co...

อ่านเพิ่มเติม »

การจัดรูปแบบเซลล์ใน Custom ให้มีสีใน Excel

<p> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"><a class="tooltip-target" data-citationid="544406ce-fa58-03cc-aa58-d68aba95ad4e-2-group" href="https://support.microsoft.com/th-th/office/%E0%B9%83%E0%B8%8A%E0%B9%89%E0%B9%81%E0%B8%96%E0%B8%9A%E0%B8%82%E0%B9%89%E0%B8%AD%E0%B8%A1%E0%B8%B9%E0%B8%A5-%E0%B8%A3%E0%B8%B0%E0%B8%94%E0%B8%B1%E0%B8%9A%E0%B8%AA%E0%B8%B5-%E0%B9%81%E0%B8%A5%E0%B8%B0%E0%B8%8A%E0%B8%B8%E0%B8%94%E0%B9%84%E0%B8%AD%E0%B8%84%E0%B8%AD%E0%B8%99%E0%B9%80%E0%B8%9E%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B9%80%E0%B8%99%E0%B9%89%E0%B8%99%E0%B8%82%E0%B9%89%E0%B8%AD%E0%B8%A1%E0%B8%B9%E0%B8%A5-f118d0a6-5921-4e2e-905b-fe00f3378fb9" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">หากต้องการจัดรูปแบบตัวเลขให้มีสีหรือเงื่อนไข คุณสามารถใช้ custom format และใส่โค้ดสีหรือเงื่อนไขได้</a> <span> </span>วิธีการคือ</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เลือกเซลล์ที่ต้องการจัดรูปแบบ</li><li>คลิกขวาแล้วเลือก Format Cells</li><li>เลือกแท็บ Number แล้วเลือกประเภท Custom</li><li>ในช่อง Type ให้พิมพ์โค้ดรูปแบบตัวเลขที่ต้องการ เช่น [Red]0.00;[Blue]-0.00;[Green]0</li><li>คลิก OK</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดสีที่ใช้ใน custom format มีดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>[BLACK], [BLUE], [CYAN], [GREEN], [MAGENTA], [RED], [WHITE], [YELLOW]</li><li>[COLOR 1-56] เป็นสีที่กำหนดจาก Theme Color</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดเงื่อนไขที่ใช้ใน custom format มีดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>; (เครื่องหมายอัญประกาศ) ใช้แยกส่วนของ custom format เป็นสี่ส่วน คือ positive;negative;zero;text</li><li>[] (วงเล็บเหลี่ยม) ใช้กำหนดเงื่อนไขที่ต้องการ เช่น [<100]0.00;[>=100]0.0</li><li>? (เครื่องหมายคำถาม) ใช้แทนตำแหน่งของตัวเลขที่ไม่จำเป็นต้องแสดง เช่น ??.??;???.??</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้ custom format เพื่อจัดรูปแบบตัวเลขตามสีหรือเงื่อนไข</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ตัวเลข</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Custom Format</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Result</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">12.34</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Red color with 12.34</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-12.34</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Blue color with -12.34</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Green color with 0</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ABC</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">No color with ABC</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">99</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[<100]0.00;[>=100]0.0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Two decimal places with 99.00</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">100</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[<100]0.00;[>=100]0.0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">One decimal place with 100.0</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-5</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">??.??;???.??</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Two spaces before -5</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-50</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">??.??;???.??</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">One space before -50</td></tr></tbody></table><p> </p>

การจัดรูปแบบเซลล์ใน Custom ให้มีสีใน Excel

  หากต้องการจัดรูปแบบตัวเลขให้มีสีหรือเงื่อนไข คุณสามารถใช้ custom format และใส่โค้ดสีหรือเงื่อนไขได้   วิธีการคือ เลือกเซลล์ที่ต้องการจัดร...

อ่านเพิ่มเติม »

การใส่เลข 0 หน้าตัวเลขใน Excel

<p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">วิธีหนึ่งในการเติมเลข 0 หน้าตัวเลขใน excel คือ<a class="tooltip-target" data-citationid="b06bbacf-d3ab-26cc-e07a-4c2bb63b8c85-4-group" href="https://support.microsoft.com/th-th/office/%E0%B8%AA%E0%B8%A3%E0%B9%89%E0%B8%B2%E0%B8%87%E0%B9%81%E0%B8%A5%E0%B8%B0%E0%B8%9B%E0%B8%A3%E0%B8%B1%E0%B8%9A%E0%B9%83%E0%B8%8A%E0%B9%89%E0%B8%A3%E0%B8%B9%E0%B8%9B%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B8%95%E0%B8%B1%E0%B8%A7%E0%B9%80%E0%B8%A5%E0%B8%82%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B8%9B%E0%B8%A3%E0%B8%B1%E0%B8%9A%E0%B9%81%E0%B8%95%E0%B9%88%E0%B8%87%E0%B9%80%E0%B8%AD%E0%B8%87-6c308025-35da-4047-9481-c146a12063df" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">การเปลี่ยนรูปแบบของตัวเลขให้เป็น custom ใน excel ซึ่งก็คือการกำหนดรูปแบบตัวเลขที่ไม่มีให้เลือกในรูปแบบมาตรฐาน โดยใช้โค้ดรูปแบบตัวเลขที่มีความหมายต่างกัน เช่น</a></p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>0 แสดงตัวเลขออกมาเสมอ ถ้าไม่มีจะเติมศูนย์</li><li><h1 style="font-size: var(--cib-type-title2-font-size); font-variation-settings: var(--cib-type-title2-font-variation-settings); font-weight: var(--cib-type-title2-font-weight); line-height: var(--cib-type-title2-line-height); margin: 0px; padding: 0px; user-select: text; word-break: break-word;">แสดงตัวเลขออกมาเฉพาะที่จำเป็น ถ้าไม่มีจะไม่แสดง</h1></li><li>. แสดงจุดทศนิยม</li><li>, แสดงเครื่องหมายคอมม่า</li><li>% แสดงเปอร์เซ็นต์</li><li>E+ E- e+ e- แสดงในรูปแบบเลขยกกำลัง</li><li>\ ใช้ escape character เพื่อแสดงตัวอักษรพิเศษ</li><li>“text” ใช้เพื่อแสดงข้อความที่กำหนด</li><li>[ ] ใช้เพื่อกำหนดสีหรือเงื่อนไข</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้โค้ดรูปแบบตัวเลข</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">โค้ด</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">ผลลัพธ์</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">คำอธิบาย</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1,234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มจุดทศนิยมสองตำแหน่งและคอมม่า</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00;[Red]-#,##0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">-1,234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มสีแดงให้กับค่าลบ</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00_);(#,##0.00)</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(1,234.57)</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มวงเล็บให้กับค่าลบ</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">0%</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">10%</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มเครื่องหมาย %</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;"># ?/?</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1 2/3</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มเศษส่วน</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#.00E+00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1.23E+03</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มรูปแบบเลขยกกำลัง</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">* #,##0 *</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">* 1,234 *</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่ม * ทั้งสองข้าง</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">"Total "0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Total 1234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มข้อความ Total</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td></tr></tbody></table><p> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">หากต้องการเติมเลข 0 ลงข้างหน้าตัวเลขเบอร์โทรศัพท์ เราสามารถใช้ custom format ใน excel ได้<span> </span>วิธีการคือ</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เลือกเซลล์ที่ต้องการจัดรูปแบบ</li><li>คลิกขวาแล้วเลือก Format Cells</li><li>เลือกแท็บ Number แล้วเลือกประเภท Custom</li><li>ในช่อง Type ให้พิมพ์โค้ดรูปแบบตัวเลขที่ต้องการ เช่น 0000000000</li><li>คลิก OK</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดรูปแบบตัวเลขที่ใช้ใน custom format จะมีหลักการดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>0 แสดงตัวเลขออกมาเสมอ ถ้าไม่มีจะเติมศูนย์</li><li><h1 style="font-size: var(--cib-type-title2-font-size); font-variation-settings: var(--cib-type-title2-font-variation-settings); font-weight: var(--cib-type-title2-font-weight); line-height: var(--cib-type-title2-line-height); margin: 0px; padding: 0px; user-select: text; word-break: break-word;">แสดงตัวเลขออกมาเฉพาะที่จำเป็น ถ้าไม่มีจะไม่แสดง</h1></li><li>\ ใช้ escape character เพื่อแสดงตัวอักษรพิเศษ เช่น -</li><li>“text” ใช้เพื่อแสดงข้อความที่กำหนด</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้ custom format เพื่อจัดรูปแบบเบอร์โทรศัพท์</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">เบอร์โทร</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Custom Format</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Result</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(000)000-0000</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(123)456-7890</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">"Tel."0000-0000</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Tel.1234-5678</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">“Call” # ### ###</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Call 1 234 567</td></tr></tbody></table>

การใส่เลข 0 หน้าตัวเลขใน Excel

วิธีหนึ่งในการเติมเลข 0 หน้าตัวเลขใน excel คือ การเปลี่ยนรูปแบบของตัวเลขให้เป็น custom ใน excel ซึ่งก็คือการกำหนดรูปแบบตัวเลขที่ไม่มีให้เลือ...

อ่านเพิ่มเติม »

ฟังก์ชั่น Select ใน AppSheet

<p> </p><p>                                                   <b>  ฟังก์ชั่น SELECT</b> </p><p> </p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 1.25em; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ฟังก์ชั่น SELECT ใน AppSheet เป็นฟังก์ชั่นที่ใช้สำหรับกรองข้อมูลในตารางหรือวิวที่สร้างขึ้นในแอปพลิเคชัน ฟังก์ชั่นนี้ช่วยให้ผู้ใช้งานสามารถเลือกแสดงเฉพาะข้อมูลที่ต้องการเท่านั้น โดยใช้เงื่อนไขหรือเปรียบเทียบค่าในแต่ละคอลัมน์</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">รูปแบบของฟังก์ชั่น SELECT จะเป็นดังนี้:</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">SELECT(Table[Column], Condition)</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">โดย Table คือชื่อตารางที่ต้องการกรองข้อมูล และ Column คือชื่อคอลัมน์ที่ต้องการกรองข้อมูล ส่วน Condition คือเงื่อนไขการกรองข้อมูล ซึ่งสามารถใช้ตัวดำเนินการต่างๆ เช่น =, <, >, <=, >=, <> และ AND, OR ได้</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ตัวอย่างการใช้งาน SELECT ใน AppSheet เพื่อกรองข้อมูลในตาราง:</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">SELECT(Orders[Customer Name], [Order Date] > "2022-01-01")</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ซึ่งจะกรองแสดงเฉพาะชื่อลูกค้าในตาราง Orders ที่มีวันที่สั่งซื้อหลังจาก 2022-01-01 เท่านั้น</p><p> </p><br /><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </p><div class="separator" style="clear: both; text-align: center;"><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPVccUYsbckDZwiFmn9ZrPlsAD3KRQx3PeGwe6lEQNGtNIGNNM6Glrdb6kdak7HbknkPb297jiyiydPX5GmsnieXuUnqA1PCzxOgT_YaMx9F5NFalrWq19a6M7woo8d9way0hB50Ai77SfyXX5M7hc3Yz_q49LZU8mB7HVcBHUaaTGlILrmla7fWnxOQ/s550/appsheet1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"> </a></div><div class="separator" style="clear: both; text-align: center;"> </div><br /><p></p><br /><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </p><p> </p>

ฟังก์ชั่น Select ใน AppSheet

                                                        ฟังก์ชั่น SELECT   ฟังก์ชั่น SELECT ใน AppSheet เป็นฟังก์ชั่นที่ใช้สำหรับกรองข้อมูล...

อ่านเพิ่มเติม »

การใช้ Flash Fill ใน Excel

<p> </p><h2 style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; padding: 0px; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; word-break: break-word; word-spacing: 0px;">                                                          การใช้ Flash Fill ใน Excel<br /></h2><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill ใน Excel เป็นเครื่องมือที่ช่วยให้คุณสามารถตัด ต่อ แปลง หรือจัดรูปแบบข้อมูลในเซลล์ได้อย่างอัตโนมัติ โดยไม่ต้องเขียนสูตร หลักการทำงานของ Flash Fill คือ Excel จะพยายามหารูปแบบ (Pattern) จากข้อมูลที่คุณใส่เป็นตัวอย่าง เพื่อให้ได้ผลลัพธ์ที่คุณต้องการ<a aria-label="งานเสร็จฉับไว ด้วย Flash Fill - เทพเอ็กเซล : Thep Excel" class="ac-anchor sup-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-2" href="https://www.thepexcel.com/flash-fill-quick-win/" style="color: var(--cib-color-brand-link-foreground); position: relative; text-decoration: none;" target="_blank"><sup style="align-items: center; background: var(--cib-color-brand-tertiary-background); border-radius: 3px; color: var(--cib-color-brand-tertiary-foreground); display: inline-flex; font-size: 10px; font-weight: 600; height: 14px; justify-content: center; margin: 0px 2px; min-width: 14px; outline: transparent solid 1px; position: relative; text-decoration-color: transparent; top: -1px; vertical-align: top;">1</sup></a><a aria-label="How to Fill Excel Cells Automatically with Flash Fill and Auto Fill" class="ac-anchor sup-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-4" href="https://www.howtogeek.com/715978/how-to-fill-excel-cells-automatically-with-flash-fill-and-auto-fill/" style="color: var(--cib-color-brand-link-foreground); position: relative; text-decoration: none;" target="_blank"><sup style="align-items: center; background: var(--cib-color-brand-tertiary-background); border-radius: 3px; color: var(--cib-color-brand-tertiary-foreground); display: inline-flex; font-size: 10px; font-weight: 600; height: 14px; justify-content: center; margin: 0px 2px; min-width: 14px; outline: transparent solid 1px; position: relative; text-decoration-color: transparent; top: -1px; vertical-align: top;">2</sup></a>.</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"><a class="tooltip-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-11-group" href="https://www.thepexcel.com/flash-fill-quick-win/" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">วิธีการใช้ Flash Fill ใน Excel มีดังนี้</a></p><ol style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เตรียมข้อมูลดิบและคอลัมน์ผลลัพธ์ที่คุณต้องการได้</li><li>ใส่ตัวอย่างผลลัพธ์ที่คุณต้องการไปซัก 1-2 บรรทัด เพื่อทำการสอน Excel</li><li>คลิกที่เซลล์ที่เราสอน (หรือจะคลิกเซลล์ข้างใต้ก็ได้) แล้วกด Ctrl+E ทีละช่อง (ทีละคอลัมน์) เพื่อใช้ Flash Fill</li><li>ถ้า Excel ให้ผลลัพธ์ผิด ก็ต้องสอนเพิ่มไปอีกซักบรรทัดนึง เพื่อให้มันฉลาดขึ้น</li></ol><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill เป็นเครื่องมือที่มีประโยชน์และสะดวกมาก แต่มันก็มีข้อเสียบ้าง เช่น</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>Flash Fill ใช้ได้แค่ Excel 2013 ขึ้นไปเท่านั้น</li><li>Flash Fill เป็นการ Stamp ค่าคงที่ลงไปแล้ว ไม่ใช่สูตร ดังนั้นถ้าข้อมูลเปลี่ยนหรือมีข้อมูลใหม่มา ผลลัพธ์จะไม่เปลี่ยนตาม</li></ul><p> </p><p><span face="-apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif" style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: inline; float: none; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">ถ้าคุณต้องการสร้างอีเมล์จากชื่อและนามสกุล คุณสามารถใช้ Flash Fill ได้ดังนี้</span> <br /></p><ol style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>ใส่ตัวอย่างผลลัพธ์ที่คุณต้องการไปซัก 1-2 บรรทัด เช่น john.smith@email.com</li><li>คลิกที่เซลล์ที่เราสอน (หรือจะคลิกเซลล์ข้างใต้ก็ได้) แล้วกด Ctrl+E ทีละช่อง (ทีละคอลัมน์) เพื่อใช้ Flash Fill</li><li>Excel จะพยายามหารูปแบบ (Pattern) จากข้อมูลที่คุณใส่เป็นตัวอย่าง เพื่อให้ได้ผลลัพธ์ที่คุณต้องการ</li></ol><p>ตัวอย่าง </p><p> <br /></p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ชื่อ</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">นามสกุล</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">อีเมล์</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">John</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Smith</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">john.smith@email.com</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">Mary</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Jones</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">mary.jones@email.com</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">Peter</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Lee</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">peter.lee@email.com</td></tr></tbody></table><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill จะเติมข้อมูลให้คุณโดยอัตโนมัติ โดยไม่ต้องเขียนสูตร</p><p>ดูตัวอย่างการใช้งาน ได้ที่   </p><p></p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="395" src="https://www.youtube.com/embed/tPqQAYcYbZI" width="475" youtube-src-id="tPqQAYcYbZI"></iframe></div><br /> <p></p><p><br /></p><p> </p><p> <br /></p><p> </p>

การใช้ Flash Fill ใน Excel

                                                            การใช้ Flash Fill ใน Excel     Flash Fill ใน Excel เป็นเครื่องมือที่ช่วยให้คุณสา...

อ่านเพิ่มเติม »

การใช้คำสั่ง TextSplit ใน Excel

<p> </p><p>สูตร TEXTSPLIT ใน Excel เป็นฟังก์ชันที่ช่วยในการแยกข้อความออกเป็นคอลัมน์หรือแถวตามตัวคั่นที่กำหนด โดยใช้ฟังก์ชันนี้จะช่วยให้ผู้ใช้สามารถแยกข้อความออกเป็นคอลัมน์หรือแถวได้อย่างง่ายดาย โดยไม่ต้องใช้วิธีการแบ่งข้อความด้วยตัวเอง ซึ่งจะช่วยประหยัดเวลาและลดความผิดพลาดได้เป็นอย่างมา</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">สูตรการใช้งาน TEXTSPLIT ใน Excel มีรูปแบบดังนี้:</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with]) </code></pre><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โดยที่:</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>text: เป็นข้อความที่ต้องการแยก</li><li>col_delimiter: เป็นตัวคั่นที่ใช้แยกข้อความเป็นคอลัมน์</li><li>row_delimiter: เป็นตัวคั่นที่ใช้แยกข้อความเป็นแถว</li><li>ignore_empty: เป็นการเลือกว่าจะไม่แสดงผลลัพธ์ที่เป็นช่องว่างหรือไม่ (TRUE/FALSE)</li><li>match_mode: เป็นการเลือกว่าจะให้การแยกข้อความเป็นตัวพิมพ์เล็กหรือตัวพิมพ์ใหญ่ (0/1)</li><li>pad_with: เป็นการเลือกว่าจะเติมช่องว่างหรือไม่ (TRUE/FALSE)</li></ul><p> ตัวอย่างการใช้งาน Textsplitที่ 1 <br /></p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">=TEXTSPLIT("apple,banana,orange",",") </code></pre><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ผลลัพธ์ที่ได้คือ</p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">apple banana orange</code></pre><p></p><p>ตัวอย่างการใช้งาน Textsplit ที่ 2</p><p>=TEXTSPLIT(<span style="-webkit-text-stroke-width: 0px; background-color: #f7f7f8; color: #374151; display: inline !important; float: none; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">A2:A4," ")</span></p><table style="--tw-border-spacing-x: 0px; --tw-border-spacing-y: 0px; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border-collapse: separate; border-color: inherit; border-image: initial; border-spacing: var(--tw-border-spacing-x) var(--tw-border-spacing-y); border-style: solid; border-width: 0px; box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 0.875em; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; line-height: 1.71429; margin-bottom: 0px; margin-top: 2em; orphans: 2; table-layout: auto; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; width: 460.994px; word-spacing: 0px;"><thead style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-th-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border: 0px solid rgb(217, 217, 227); box-sizing: border-box;"><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-top-left-radius: 0.375rem; border-width: 1px 0px 1px 1px; box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">ชื่อ - นามสกุล</th><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 1px 0px 1px 1px; box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">First Name</th><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-top-right-radius: 0.375rem; border: 1px solid rgb(217, 217, 227); box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">Last Name</th></tr></thead><tbody style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border: 0px solid rgb(217, 217, 227); box-sizing: border-box;"><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">John Doe</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">John</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Doe</td></tr><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jane Smith</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jane</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Smith</td></tr><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-left-radius: 0.375rem; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jim Brown</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jim</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-right-radius: 0.375rem; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Brown</td></tr></tbody></table><p></p><p><br /></p><p>ตัวอย่างการใช้งานอื่น ๆ ดูได้ที่ </p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="431" src="https://www.youtube.com/embed/U-fShUldU1A" width="518" youtube-src-id="U-fShUldU1A"></iframe></div><br /><p><br /></p><p><span style="-webkit-text-stroke-width: 0px; background-color: #f7f7f8; color: #374151; display: inline !important; float: none; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </span> <br /></p>

การใช้คำสั่ง TextSplit ใน Excel

  สูตร TEXTSPLIT ใน Excel เป็นฟังก์ชันที่ช่วยในการแยกข้อความออกเป็นคอลัมน์หรือแถวตามตัวคั่นที่กำหนด โดยใช้ฟังก์ชันนี้จะช่วยให้ผู้ใช้สามารถแย...

อ่านเพิ่มเติม »