"LEFT, MID, dan RIGHT di Google Sheets | Extract Data from Product Codes (ID & EN)"

📊 LEFT, MID, dan RIGHT di Google Sheets | Extract Product Code (Bilingual)

Bahasa: Indonesia & English

🇮🇩 Studi Kasus

Dalam studi kasus video, kita diberikan contoh format kode produk dengan struktur:

  • 3 huruf pertama: Nama/Singkatan produk
  • 3 angka di tengah: Berat produk
  • 3 huruf terakhir: Lokasi penjualan

Untuk mengekstrak data ini, kita menggunakan fungsi Excel LEFT, MID, dan RIGHT.

🇬🇧 Case Study

In this case study, a product code is formatted as follows:

  • First 3 letters: Product name or abbreviation
  • Middle 3 digits: Product weight
  • Last 3 letters: Sales location

We’ll use Excel’s LEFT, MID, and RIGHT functions to extract this information.

🔹 LEFT Function – Nama Produk / Product Name

=LEFT(A3, 3)

ID: Mengambil 3 karakter pertama dari kiri.

EN: Extracts the first 3 characters from the left.

Contoh: MIL250JKT → MIL

🔹 MID Function – Berat Produk / Product Weight

=MID(A3, 4, 3)

ID: Mulai dari karakter ke-4, ambil 3 karakter.

EN: Starts from the 4th character, extracts 3 characters.

Contoh: MIL250JKT → 250

🔹 RIGHT Function – Lokasi Penjualan / Sales Location

=RIGHT(A3, 3)

ID: Mengambil 3 karakter paling kanan.

EN: Extracts the last 3 characters from the right.

Contoh: MIL250JKT → JKT

✅ Tips Tambahan / Additional Tips

  • ID: Pastikan panjang kode selalu 9 karakter agar hasil rumus tepat.
  • EN: Ensure code length is always 9 characters for accurate results.
  • ID: Gunakan TRIM jika ada spasi berlebih.
  • EN: Use TRIM if extra spaces exist.

💬 Sudah pernah coba rumus ini? Bagikan pengalamanmu di kolom komentar!

Comments

Post a Comment

Popular posts from this blog

Learn SUM, AVERAGE, MIN & MAX in Google Sheets – Beginner Tutorial

📌 Learning Basic Formulas: SUM, AVERAGE, MAX, and MIN in Google Sheets Hello! In this article, I’d like to share one of my first steps in learning Google Sheets — especially how to use some of the basic formulas that are essential for office tasks or everyday work. Google Sheets (or Excel) is a powerful tool used in many types of jobs. Understanding basic formulas like SUM, AVERAGE, MIN, and MAX can really help you to: Create sales reports Analyze data Manage budgets or student scores And so much more! I also made a silent video tutorial, which you can follow along. Watch the video below, and then read the explanation of each step. 📝 Step-by-Step Guide:      1️⃣ Open Google Sheets              Go to Google Sheets and click on Blank to create a new spreadsheet.      2️⃣ Enter or Paste Your Data              Create data just like in the video. If you already have data in Exce...
Read more

Pengalaman Menjadi Account Receivable (AR): Tips, Tantangan, dan Keterampilan Penting

Image
--> Pengalaman Menjadi Account Receivable (AR): Tantangan, Tips, dan Keterampilan yang Dibutuhkan ID: Selama beberapa tahun terakhir, saya pernah bertugas sebagai staf Account Receivable (AR) di berbagai perusahaan yang bergerak di bidang berbeda—mulai dari industri penerbangan, distribusi alat kesehatan, retail, hingga trading. Meskipun inti pekerjaan AR cenderung serupa, setiap bidang memberikan tantangan dan pengalaman unik dalam mengelola piutang dan menjalin komunikasi dengan pelanggan. EN: Over the past few years, I have served as an Account Receivable (AR) staff in several companies across different industries — from aviation, medical equipment distribution, retail, to trading. Although the core responsibilities are similar, each industry offered its own unique challenges and experiences in managing receivables and maintaining client communication. Apa Itu AR? / What is AR? ID: AR adalah bagian dari divisi Finance yang fokus pa...
Read more