Automatically translated.View original post

EazyIT by Patrick

7334 followers

Follow

Follow

Follow

17 saved

24

Replace text or words on Excel

Replace text or words on Excel 🤩💼

# Excel # Excel formula # Excel the basics # exceltips # Lemon 8 Howtoo

2025/11/24 Edited to

ถ้าคุณเคยเจอปัญหาที่ต้องแก้ไขข้อความหลาย ๆ จุดใน Excel การใช้ฟังก์ชัน SUBSTITUTE จะช่วยให้คุณทำงานได้ง่ายขึ้นมากครับ ตัวอย่างเช่น ถ้าคุณมีรายชื่อชื่อที่เต็มไปด้วยคำนำหน้า "Mr." และต้องการเปลี่ยนเป็น "คุณ" ให้เหมือนกันทั้งหมด คุณสามารถใช้สูตร =SUBSTITUTE(B2,"Mr.","คุณ") ในเซลล์ที่ต้องการ ผลลัพธ์จะได้ชื่อที่แก้ไขเรียบร้อยแล้วโดยไม่ต้องแก้ไขทีละเซลล์ ผมชอบฟังก์ชันนี้เพราะมันใช้งานง่ายและสามารถประยุกต์ใช้กับข้อมูลหลายรูปแบบ นอกจากนี้ยังช่วยลดความผิดพลาดจากการแก้ไขมือ การใช้ SUBSTITUTE ไม่จำเป็นต้องติดตั้งโปรแกรมเสริมหรือสคริปต์ใด ๆ ทำให้ทำงานใน Excel ได้ทันที สำหรับใครที่อยากลองใช้ ผมแนะนำให้เปิด Excel ขึ้นมา แล้วลองใส่คำข้างต้นในเซลล์ B2 และลองใส่สูตรนี้ดู จากนั้นคุณจะเห็นว่าฟังก์ชันแทนที่ข้อความนี้ทำงานได้เร็วและสะดวกแค่ไหน นอกจากนี้ถ้าต้องการแทนที่คำหลายคำ คุณสามารถใช้ฟังก์ชัน SUBSTITUTE ซ้อนกันหรือลองใช้ฟังก์ชันอื่น ๆ ร่วมด้วยเพื่อความยืดหยุ่นที่มากขึ้น ถือว่านี่เป็นเทคนิคง่าย ๆ ที่ช่วยให้การจัดการข้อมูลใน Excel ของคุณสะดวกและรวดเร็วขึ้นมากครับ

Related posts

A tablet displays an Excel wedding budget spreadsheet on a desk with notes and a planner. The image is titled 'Stop Struggling with Excel Learn These Super Easy Formulas'.

This image details core Excel calculation formulas: SUM, AVERAGE, MIN, and MAX. Each function is explained with an example Excel table showing its application and purpose.

This image explains Excel's reference formulas, VLOOKUP and HLOOKUP. It provides examples with tables demonstrating how to search and retrieve data vertically and horizontally, along with usage tips.

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1182 likes

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.

This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.

This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).

Excel shortcuts every student should know! 👩🏻‍💻

Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become

2718 likes

Excel import magic

Excel magic at its finest. Import data from picture whether it’s a photo from your phone or a screenshot. #tutorial #exceltips #exceltricks #exceltraining #exceltutorial

373 likes

Excel quick search tabs instead of scrolling trick

Excel quick search tabs instead of scrolling trick #tutorial #exceltips #exceltricks #excel _learning #exceltraining #learn #excelforbeginners #fyp

18 likes

A person photographs a neatly organized desk setup with a tablet displaying food, a notebook, and various study/lifestyle items. The image introduces "Side Projects to Start Instead of Scrolling" with the creator's handle.

This image lists five "Low Energy" side projects to replace scrolling, including curating a Spotify playlist, starting a Duolingo streak, learning Rubik's Cube, organizing Pinterest boards, and watching a Crash Course video.

This image presents five "Medium Energy" side projects, such as creating a website, taking free online courses, cooking a new dish, planning groceries, and trying a thrift flip project.

Side Projects to Replace Mindless Scrolling

🌱 Low Effort / Low Resource Projects This is my "I'm too tired to think, but too bored to do nothing" list. The goal is to replace passive scrolling with a slightly more active habit, with zero pressure. My go-to's are things like curating a very specific Spotify playlist, starting

276 likes

100 Excel Shortcuts

#excelshortcuts #excelformulas #exceltips

746 likes

Excel vs Word #excel #exceltricks #exceltips #exceltutorial

Excel vs Word #excel #exceltricks #exceltips #exceltutorial

415 likes

Study tips to help you excel in your exams 🍋

📝Daily affirmations - Straight A's are not negotiable - GPA reflection of my dedication - Study techniques that changed my life - From average to academic weapon - Transforming my grades completely - Study methods that actually work #StudyTok #studyWithMe #studyMotivation

6 likes

A vibrant graphic titled 'USEFUL EXCEL FORMULAS' in green, overlaid on a spreadsheet displaying various charts, data tables, and financial figures. The image includes 'Career | Lemon 8' branding and a 'SWIPE' indicator.

A laptop screen showing code, with a text box explaining the 'VLOOKUP' Excel formula. It defines its function for searching large datasets and provides a detailed example. The image is branded 'Career | Lemon 8 | Yun Jung'.

A text box on a wooden desk with a laptop, smartphone, and coffee cup, explaining 'SUMIF & SUMIFS' Excel formulas. It defines their use for adding cells based on conditions and provides a SUMIF example. The image is branded 'Career | Lemon 8 | Yun Jung'.

Useful Excel Formulas to save your time at work!

Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and

872 likes

Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning

4948 likes

Excel list comparison 🌸

So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #

4457 likes

Blank EXCEL template for school nurses!

As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow

73 likes

This image displays a Microsoft Excel Cheat Sheet covering basic skills, including the program screen, keyboard shortcuts, navigation, and formatting. It features a 'Swipe' overlay, indicating more content is available.

This image shows a Microsoft Excel Cheat Sheet focused on advanced skills, specifically detailing PivotTable elements, fields, layout, and charts. It provides a comprehensive guide to using PivotTables in Excel.

How to get the excel Cheatsheet pdf?

I just made my own website : valder.org A lot of free data resources will share on it. If you are a student in college you can follow to get more.

59 likes

Excel shortcuts are easy to remember with cheat sheets like the ABC’s. These are some of the most common shortcuts to use. #excel #exceltraining #exceltips #exceltricks #excelpro #alwayslearning

33 likes

Save these Useful Excel Shortcuts!

Hey everyone! Excel shortcuts are super helpful for getting things done faster and smoother. They range from simple tricks for moving around your spreadsheet to more advanced ones for formatting and data manipulation. Mastering these shortcuts can really save you time and make you more efficient! I

296 likes

A detailed Excel Cheat Sheet page covering 'Edit a Workbook', 'Basic Formatting', 'Insert Objects', 'View and Manage Worksheets', and 'Basic Formulas' with instructions and examples.

1/3: Ultimate Excel Cheatsheet You Should Know

Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p

540 likes

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to

1436 likes

Excel's Secret Weapon: The Power of F4 Key! 🔄✨

💡 Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of the F4 Key! Ever wished you could repeat your last action instantly? That’s exactly what F4 does—whether it's formatting cells, inserting rows, or adjusting formulas, one tap of F4 and you’re good to go! 🎉 Say

4 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

ANALYZE DATA - EXCEL TOOL

Excel's Analyze Data Tool is a game-changer, simplifying the way you work with data. Say goodbye to the days of laboriously creating tables and charts and struggling with formatting intricacies. This tool automates the process, making data analysis and visualization effortless. With just a f

252 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

54 likes

Sequence in excel or google sheets

The =SEQUENCE function in Google Sheets is a game changer for generating numbers automatically. No more typing rows manually. In this quick tutorial I’ll show you how it works and how you can use it in real projects. #googlesheets #exceltips #spreadsheettips #googlesheetstricks #datame

7 likes

How to Find Cube Roots in Excel

How to Find Cube Roots in Excel #excel #exceltips #exceltricks #exceltutorial #msexcel

0 likes

Excel cheatsheet:5/20, one page equals a book

https://hf.datarails.com/ #excel -sheets 💅🏾🏙️📜🧐🤔🤨😀🤩💋👌🏾👄

2 likes

Excel projects with a Gantt chart

Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips

11 likes

Easy way for sum in excel

Easy way for Sum in excel #exceltraining #excelformula #excelformulas #exceltutorial #exceltips

0 likes

How to Create an Email ID using CONCAT in Excel

How to Create an Email ID using CONCAT Function in Excel #exceltraining #exceltricks #exceltutorial #excelsheets #msexcel

1 like

Excel's Most Powerful Trick-Ctrl+E

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in

150 likes

How to add Filter on your worksheet in Excel

How to add Filter on your worksheet in Excel #exceltricks #exceltutorial #excel #excelsheets #exceltips

2 likes

Excel percent format issue trick

Excel percent format issue trick. Fix percentage issues. #tutorial #exceltips #excel #excelpro #exceltricks #exceltutorial #exceltraining

11 likes

A smiling woman in a black puffer jacket, white scarf, and earmuffs holds a book and coffee cup in front of a festive market stall. Overlaid text reads: "MUST HAVE SCHEDULE FOR LAZY STUDENT."

A woman wearing headphones works on a laptop, illustrating the morning study block. Overlaid text details "Morning (9-11am)", "Wake up and hydrate", and "Do 1 focused study block (max 1hr)" on a priority topic.

A woman relaxes on a couch, reading a book, with a small dog on the windowsill. Overlaid text describes the "Afternoon (1-3pm)" activities: "Rest / scroll / vibe" and "Passive learning" via media.

How you can excel at school (the lazy way)

This one’s for my fellow lazy-but-ambitious besties 💅 You want good grades, but motivation? Rare. Energy? Inconsistent. Attention span? Fighting for its life. LOL. So I made a schedule that actually works when you’re low-effort but still want to see results. Here’s the lazy but it works ro

51 likes

How to Create a Pie Chart in Excel

How to Create a Pie Chart in Excel #excel #exceltips #exceltutorial #exceltipsandtricks #microsoftexcel

0 likes

How to Delete Rows in Excel Easily using Just your Keyboard

How to Delete Rows in Excel instantly using just your Keyboard #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

1 like

How to Find Cube of any Numbers in Excel

How to Find Cube of any Numbers in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

0 likes

Level Up Your Excel Game with VLOOKUP Function! 📈🌟

👉 Welcome to Our Excel Mini-Class! 💡 Today's session is all about VLOOKUP Function in Excel! Ever feel like searching for specific data in a huge spreadsheet is like finding a needle in a haystack? 🧐 VLOOKUP is here to help! With a simple setup, you can make it simple to locate exactly what

8 likes

How to Multiply Numbers in Excel

In this video, I will be explaining how to Multiply Numbers in Excel #exceltips #exceltricks #exceltraining #exceltutorial #excel

0 likes

Excel differences in columns

Find the differences between these columns in Excel with these Excel tricks #excel #exceltraining #exceltips #excel _learning #tutorial #excel_learning #excelforbeginners #fyp

36 likes

Excel interview tips

Excel interview tips #exceltips #interviewtips #exceltraining #excel #business

18 likes

Excel Spreadsheet & Google Sheets Template

Most businesses lose money and time because they forget renewals, licenses, and subscriptions. This template helps you stay fully organized: ✔ Track all expiration dates ✔ Assign renewal owners ✔ Avoid missed deadlines ✔ See everything in one dashboard Built for Excel & Google Sheets.

1 like

How to use NOT Function in Excel

In this video, I will be explaining in details how to use NOT Function in Excel #excel #exceltips #exceltraining #exceltutorial #microsoftexcel

0 likes

#excelspreadsheets #

6 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2583 likes

Excel signature

Yes a handwritten signature imported in excel #exceltips #exceltricks #exceltraining #exceltutorial #excel

188 likes

Copy paste unique only in excel trick

Copy just the unique values in excel #exceltraining #exceltips #exceltricks #tutorials #excelforbeginners

13 likes

Things that helped me excel as an online student

How to excel as an online student: planner📚: Keep a physical or online copy of a planner with you!! Planning out each day or writing down what classes you have at what time or what assignments are due each week will help you be prepared. Since you’re doing school online you won’t have a professor

47 likes

How to Filter in Excel

In this video, i will be explaining in detail how to Filter in Excel #excel #exceltips #exceltipsandtricks #exceltutorial #microsoftexcel

0 likes

Unlock Excel's Secret Weapon with One Shortcut! ✨

💫 Welcome to Our Excel Mini-Class! 🥳 Today's session is all about the magic of Ctrl + E ! Are you tired of manually filling in data or looking for a faster way to complete tasks? Well, I've got you covered with a quick tip that'll make you a productivity pro. 💼✨ With Ctrl + E , you

421 likes

See more