Featured Posts

CS50 Python , Nutrition Facts Table

-
Image
Nutrition Facts: Python Practice for Beginners Nutrition Facts Table for Python Practice Welcome to this comprehensive guide for Python beginners! If you are learning how to work with lists, dictionaries, and loops, this post will help you build practical skills using a real-world example: nutrition facts for fruits. Understanding how to organize and manipulate data is a key part of programming, and this exercise will give you hands-on experience. Below is a sample table of fruits and their calorie values, formatted as a Python list of dictionaries. This structure is ideal for coding exercises, projects, or even building your own nutrition calculator. You can expand this list, add new fruits, or use it as a foundation for more advanced Python tasks. Python List of Dictionaries Example: fruits = [ {'name': 'Apple', 'calories': 130}, {'name': 'Avocado', 'calories': 50}, {'name': 'Banana', 'ca...
Post a Comment

How to Remove Spaces from an Excel String Cell

-
Document

 Easy Formulas to Remove Spaces

How to use Excel formulas to remove leading, trailing, and extra spaces
Excel formulas to remove spaces and clean your data efficiently.

Simply, the paces inside an Excel string Cell are either:

  • leading/starting spaces
  • Mid spaces
  • Trailing/ending spaces
Plus, if you are exporting the data from the internet or a database, you may have some problematic characters (unprintable or 7-bit ASCI characters). We will handle this too.

✋ Before we start, we will assume that the data is in cell A1. We will insert the formulas starting from B1.Feel free to change cells reference to your references.

How to remove all extra spaces from an Excel cell?

This will include leading, mid, and trailing spaces

=TRIM(A1)

or

=SUBSTITUTE(A1," ","")

Remove Spaces and Clean Unprintable Characters

=TRIM(CLEAN(A1))

You may still see characters like(� , ⌷ , ¶) which are called "unprintable characters". How to remove them? 

 Most famous codes for the unprintable characters are:

  • char(160) → �
  • char(127) → ⌷
  • char(182) → ¶

To remove these characters, you add them inside a SUBSTITUTE function (or a nested SUBSTITUTE function).
We will assume that we both � and ⌷ inside our string cell. So, we must have 2 SUBSTITUTE functions nested for each. Remember: � is char(160), ⌷ is char(127).

=TRIM(CLEAN(SUBSTITUTE(SUBSTITUTE(A2,CHAR(160),""),CHAR(127),"")))


And a bonus:

How to delete blank rows with keyboard shortcuts:

How to quickly delete blank rows in Excel using Go To Special
Step-by-step guide to delete blank rows and clean your Excel dataset.

  1. Click on top of the column to highlight it all. or, inside any cell of the column Ctrl+Spacebar
  2. Press F5
  3. Click on Special
  4. Click on Blanks
  5. Press on Ctrl+-
  6. Choose "Entire row" and press ok or Enter


Comments

Post a Comment

Your opinion matters, your voice makes us proud and happy. Your words are our motivation.

Popular posts from this blog

فرصتك للدراسة في ألمانيا: منحة ممولة بالكامل لطلاب الدراسات العليا

-
Image
منح الدراسات العليا في ألمانيا (Scholarships for Graduate Studies in Germany) DAAD ألمانيا - منحة دراسة من فرصة ذهبية للدراسة في ألمانيا: منحة دراسية ممولة بالكامل لطلاب الدراسات العليا نظرة عامة: يسّر برنامج المنح الدراسية الألمانية دااد DAAD أن يقدّم لكم الفرصة لمواصلة تعليمكم الأكاديمي في ألمانيا من خلال دراسة عليا. يتم تمويل هذه المنح الدراسية من قبل وزارة الخارجية الألمانية الاتحادية. من يمكنه التقدم؟ يمكن التقدّم لمن أكملوا الدرجة الجامعية الأولى (بكالوريوس أو دبلوم على سبيل المثال) كحد أقصى بحلول وقت بدء فترة التمويل. يرجى ملاحظة: بالنسبة للمتقدمين من التخصصات الفنية ومجال الهندسة المعمارية ، تقدم DAAD برامج المنح الدراسية التالية: العمارة Architecture فن الأداء Performing Art الموسيقى Music الفنون الجميلة / التصميم / السينما Fine Art/Design/Film ما الذي يمكن تمويله؟ يوفر البرنامج التمويل ل: برنامج كامل للدراسات العليا أو درجة الماجستير مكتمل في إحدى الجامعات الحكومية أو المعترف بها من قبل الدولة في ألمانيا أو سنة واحدة من الدراسة في ألمانيا كجزء من درجة ثانية أو ماجستير مكتملة ...
Read more »»

How to Deactivate Screen Reader in Kali Linux

-
Image
 Deactivating Screen Reader in Kali Linux How to deactivate screen reader in Kali Linux Sometimes, you suddenly hear a screen reader whenver you hover on a menu with your mouse inside Kali Linux machine. This behavior even starts from the login screen, and continues to reading anything you write in the terminal.  Before moving on to the solution, let's get to know know the problem first.  What is ORCA or the Screen Reader in Kali Linux? The screen reader in this case is called "ORCA". Orca in the context of Kali Linux, or any other Linux distribution, is a free, open-source screen reader that provides access to the graphical desktop environments. It is designed to help visually impaired users use software applications and navigate the operating system. Orca works by converting on-screen content into speech and Braille output, enabling users who are blind or have low vision to interact with their computers more easily. If this behavior is annoying or it has been acced...
Read more »»

Murphy's Law: Expect the Unexpected

-
Image
  Have you ever heard of Murphy's Law? What is Murphy's Law? It's a principle that states, "Anything that can go wrong will go wrong." This law, also known as Murphy's Principle or Murphy's Rule, highlights the tendency of things to go awry and cause problems. Understanding Murphy's Law can help us prepare for potential setbacks and approach them with a proactive mindset. In this blog post, we'll explore the essence of Murphy's Law and its significance in various fields. The Origin of Murphy's Law: Murphy's Law finds its roots in the work of an American aerospace engineer named Edward Murphy. During the 1950s, Murphy discovered that errors in technical designs often occurred due to the neglect or oversight of potential failure factors. This realization led to the formulation of what we now know as Murphy's Law. At its core, Murphy's Law suggests that if something has the potential to go wrong, it will undoubtedly go wrong at som...
Read more »»

Python 3.2.1.14 LAB: Essentials of the while loop

-
Image
3.2.1.14 LAB: Essentials of the while loop Essentials of the While Loop If you're taking PCAP - Programming Essentials In Python , you may have encountered this question 3.2.1.14 LAB: Essentials of the while loop. Objectives Familiarize the student with: using the while loop; finding the proper implementation of verbally defined rules; reflecting real-life situations in computer code. Scenario Listen to this story: a boy and his father, a computer programmer, are playing with wooden blocks. They are building a pyramid. Their pyramid is a bit weird, as it is actually a pyramid-shaped wall - it's flat. The pyramid is stacked according to one simple principle:  👉 each lower layer contains one block more than the layer above 👈 . The figure illustrates the rule used by the builders: building blocks Your task is to write a program which reads the number of blocks the builders have, and outputs the height of the pyramid that can be built using these blocks. Note: the height is m...
Read more »»

Data Analysis Roadmap 2026: From Excel Lover to Python-Powered Analyst

-
Image
 Data Analysis Roadmap 2026 Data Analysis Roadmap 2026 Ever looked at a spreadsheet and thought, "There has to be a smarter way to do this"? You're right. The difference between an Excel user and a data analyst isn't magic—it's a clear roadmap. In 2026, data analysis skills are non-negotiable. Companies aren't just collecting data anymore; they're drowning in it. And those who can turn raw numbers into actionable insights? They're the ones shaping decisions, driving revenue, and getting hired first. Here's your practical 6-month blueprint to transform from "I use Excel" to "I build automated analytics pipelines." The Four Pillars Every Data Analyst Needs: Think of data analysis like building a house. You can't jump straight to the roof. You need a solid foundation, proper structure, electrical systems, and interior finishing. Same with analytics. Here are the four pillars that successful analysts master: 1. **Data Literac...
Read more »»