Remove Whitespace Excel

To solve the problem of unwanted whitespace in Excel, which can mess up your data analysis, sorting, and lookups, here are the detailed steps to remove whitespace in Excel quickly and efficiently:

First, let’s tackle the common culprits. Most of the time, when we talk about removing whitespace in Excel, we’re dealing with leading spaces (spaces at the beginning of the text), trailing spaces (spaces at the end), and multiple spaces between words that should only have one.

Here’s your step-by-step guide:

For Standard Whitespace (Leading, Trailing, and Multiple Internal Spaces):
- The Go-To Formula: Use the TRIM function. This is your first line of defense for most whitespace issues.
- How to Apply: If your data is in cell A1, in an adjacent empty cell (say, B1), type =TRIM(A1).
- Drag Down: Hit Enter, then click on cell B1, grab the small square (fill handle) at the bottom-right corner, and drag it down to apply the formula to your entire column of data. This will remove leading whitespace Excel, trailing whitespace, and condense multiple internal spaces to a single one.
- Finalize (Optional but Recommended): To replace the original data with the cleaned version, select the new column (e.g., column B), copy it (Ctrl+C), then select the original column (e.g., column A), right-click, choose “Paste Special,” and select “Values” (or press Alt+E, S, V). This effectively makes the TRIM function’s output static text, eliminating the formula.

For ALL Whitespace (Including Spaces Between Words):

0.0

0.0 out of 5 stars (based on 0 reviews)

Excellent0%

Very good0%

Average0%

Poor0%

Terrible0%

There are no reviews yet. Be the first one to write one.

Amazon.com: Check Amazon for Remove whitespace excel
Latest Discussions & Reviews:

The SUBSTITUTE Power-Up: If you need to eliminate every single space character (e.g., turning “P R O D U C T 1 2 3” into “PRODUCT123”), the SUBSTITUTE function is your friend.
How to Apply: In an empty cell, type =SUBSTITUTE(A1," ","").
Understanding It: This formula tells Excel to look in cell A1, find every instance of a space (" "), and replace it with nothing ("").
Drag and Paste: Similar to TRIM, drag this formula down and then use “Paste Special” > “Values” if you want to replace your original data.

For Tricky, Non-Standard Whitespace (Like Non-Breaking Spaces or Non-Printable Characters):
- The CLEAN and CHAR Combo: Sometimes, data imported from web pages or other systems might contain non-breaking spaces (often CHAR(160)) or other non-printable characters that TRIM alone won’t catch. This is where CLEAN and SUBSTITUTE with CHAR come in handy.
- Non-Breaking Space: To remove CHAR(160) specifically, use =SUBSTITUTE(A1,CHAR(160),"").
- Robust Cleaning: For a truly comprehensive clean-up, combine them: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," "))). This formula first replaces non-breaking spaces with regular spaces, then CLEAN removes other non-printable characters, and finally, TRIM handles the standard leading, trailing, and extra internal spaces. This combination is excellent for a thorough eliminate whitespace Excel approach.
Remove Whitespace Excel Column: Once you’ve applied any of these formulas to the first cell in a new column, dragging the fill handle down will automatically remove whitespace for the entire Excel column. Then, use “Paste Special” > “Values” to embed the cleaned data directly into your desired column.
Remove White Space Excel Print and Chart: Once the data is cleaned and pasted as values, Excel treats the cleaned text as the actual cell content. This means any charts created from this data or any printouts of your spreadsheet will reflect the data without the unwanted whitespace. There’s no separate “remove white space Excel print” or “remove white space Excel chart” function; it’s all about cleaning the source data itself.

These methods cover the vast majority of scenarios for cleaning your Excel data, making your spreadsheets more robust and reliable for analysis and presentation.

Table of Contents

Mastering Whitespace Removal in Excel: A Comprehensive Guide

Excel is a powerhouse for data analysis, but often, the data we work with isn’t as clean as we’d like. One of the most common culprits for frustrating errors and inconsistent results is unwanted whitespace. Whether it’s leading spaces, trailing spaces, multiple spaces between words, or even non-printable characters, these seemingly innocuous gaps can wreak havoc on your formulas, sorting, and lookups. Think of it like a perfectly brewed cup of coffee—you want the pure, rich flavor, not extra grounds floating around. Just as a disciplined approach to finances leads to greater prosperity, a disciplined approach to data cleaning ensures your Excel spreadsheets are robust and reliable. Let’s deep dive into the various methods and best practices to remove whitespace in Excel, ensuring your data is pristine.

Understanding the Types of Whitespace and Their Impact

Before we jump into the solutions, it’s crucial to understand what kind of whitespace we’re dealing with and why it matters. Not all spaces are created equal in Excel.

Leading and Trailing Spaces

These are extra spaces at the very beginning or end of a cell’s content. For example, " Apple" or "Orange ".

Impact: These are incredibly problematic for VLOOKUP, MATCH, and other lookup functions, as " Apple" is considered different from "Apple". They also affect sorting order and can make data look messy. Imagine trying to categorize fruits, and ” Apple” ends up in a different spot than “Apple” just because of an invisible character. This is akin to a minor oversight in a business deal that can lead to significant losses.

Multiple Spaces Between Words

This occurs when there’s more than one space character separating words, like "Red Car".

Impact: While less critical for lookups than leading/trailing spaces, they can still cause issues with data standardization, text-based operations, and simply make your reports look unprofessional. Data presentation is key, and excessive spaces can undermine clarity.

Non-Breaking Spaces (NBSP) and Other Non-Printable Characters

These are trickier. A non-breaking space (ASCII character 160 or CHAR(160)) looks like a regular space but isn’t treated as such by standard TRIM functions. Other non-printable characters might include carriage returns (CHAR(13)), line feeds (CHAR(10)), or tabs (CHAR(9)) often imported from web pages or external systems. Ai sound generator online

Impact: TRIM won’t remove CHAR(160), leading to persistent “invisible” spaces that break lookups and comparisons. CLEAN functions typically handle non-printable characters, but NBSPs are often missed. These hidden characters are like unseen risks in an investment—they can quietly erode your returns if not identified and managed. A diligent approach to data cleanup is paramount, just as careful due diligence is essential before any significant financial commitment.

The Powerhouse: `TRIM` Function Explained

The TRIM function is Excel’s primary tool for cleaning up standard whitespace. It’s simple, effective, and should be your go-to for most scenarios.

How `TRIM` Works

The TRIM function removes all spaces from text except for single spaces between words. Specifically, it:

Removes all leading spaces.
Removes all trailing spaces.
Converts any sequences of multiple spaces between words into a single space.

Practical Application of `TRIM`

Let’s say you have messy data in column A, starting from A1.

New Column Creation: Insert a new column next to your data (e.g., column B).
Formula Entry: In cell B1, type the formula: =TRIM(A1).
Fill Down: Press Enter. Then, click on cell B1, and double-click the small green square (fill handle) at the bottom-right corner of the cell. This will copy the formula down to apply it to all relevant cells in column A. You’ll instantly see the cleaned data in column B.
Replace Original Data (Optional but Recommended): If you want to replace your original messy data with the clean version:
- Select the entire column B (your cleaned data).
- Copy it (Ctrl+C).
- Select cell A1 (or the first cell of your original data).
- Right-click, select “Paste Special,” and then choose “Values” (or press Alt+E, S, V). This pastes only the results of the TRIM function, not the formulas.
- You can now safely delete column B if you wish. This is the most common way to remove whitespace Excel column-wide.

When to Use `TRIM`

TRIM is perfect for:

Cleaning up data imported from external sources, web pages, or databases.
Ensuring consistency for lookups (e.g., VLOOKUP, INDEX/MATCH).
Preparing data for sorting and filtering.
Improving the visual presentation of your data.

A survey by IDC found that data professionals spend up to 50% of their time cleaning data. TRIM can significantly reduce this overhead for whitespace issues. Ai voice changer online free

Deep Cleaning: `SUBSTITUTE` for Specific Characters

While TRIM handles standard spaces, sometimes you need more granular control, especially when dealing with non-breaking spaces or if you want to remove all spaces, including those between words. This is where the SUBSTITUTE function shines.

`SUBSTITUTE` for Removing All Spaces

If your goal is to concatenate text or remove all spaces from a numerical string (e.g., “123 456” becoming “123456”), SUBSTITUTE is the answer.

Formula: =SUBSTITUTE(A1," ","")
Explanation: This formula instructs Excel to look at the text in cell A1, find every occurrence of a single space (" "), and replace it with an empty string ("").
Application: Enter this formula in an adjacent cell, drag it down, and use “Paste Special” > “Values” if you wish to overwrite the original data.

`SUBSTITUTE` for Non-Breaking Spaces (`CHAR(160)`)

Non-breaking spaces (NBSP) are a frequent source of frustration because they look identical to regular spaces but are character code 160 instead of 32. TRIM ignores them.

Formula: =SUBSTITUTE(A1,CHAR(160),"")
Explanation: This formula specifically targets character code 160 and replaces it with nothing.
Combined with TRIM: Often, you’ll encounter both standard spaces and NBSPs. A robust approach is to first deal with NBSPs and then TRIM the result:
=TRIM(SUBSTITUTE(A1,CHAR(160)," "))
Here, we replace the NBSP with a regular space, then TRIM handles that regular space (and any other standard spaces) properly.

`SUBSTITUTE` for Other Non-Printable Characters

Sometimes data imports bring in hidden characters like line breaks (CHAR(10)) or carriage returns (CHAR(13)), which can disrupt single-line display or cause formula errors. While CLEAN is generally better for these, SUBSTITUTE offers specific targeting.

To remove line breaks: =SUBSTITUTE(A1,CHAR(10),"")
To remove carriage returns: =SUBSTITUTE(A1,CHAR(13),"")
To remove tabs: =SUBSTITUTE(A1,CHAR(9),"")
Combined: You can nest SUBSTITUTE functions for multiple types:
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),""),CHAR(160)," "))
This formula progressively removes line breaks, carriage returns, and then non-breaking spaces (converting them to standard spaces) before TRIM performs its final cleanup. This is a powerful remove whitespace Excel formula for comprehensive cleaning.

The `CLEAN` Function: Tackling Non-Printable Characters

The CLEAN function is specifically designed to remove non-printable characters from text. These are often characters with ASCII values 0 through 31, which don’t have a visual representation but can cause issues with data processing and display. Ai voice changer online

How `CLEAN` Works

CLEAN removes all non-printable characters from text. It doesn’t, however, remove spaces (like leading, trailing, or multiple internal spaces) or non-breaking spaces (CHAR(160)).

Practical Application of `CLEAN`

Formula: =CLEAN(A1)
Application: Use it just like TRIM and SUBSTITUTE by entering it in an adjacent column, filling down, and then using “Paste Special” > “Values” if desired.

Combining `CLEAN` with `TRIM` and `SUBSTITUTE`

For the most robust data cleaning, especially with data imported from diverse sources, combining CLEAN, TRIM, and SUBSTITUTE (for NBSP) is often the best strategy.

Robust Cleaning Formula: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
- Step 1 (SUBSTITUTE(A1,CHAR(160)," ")): Replaces all non-breaking spaces (character 160) with standard spaces. This ensures TRIM can later handle them.
- Step 2 (CLEAN(...)): Removes any other non-printable characters (like line breaks or tabs) from the result of Step 1.
- Step 3 (TRIM(...)): Finally, TRIM takes the output from CLEAN, removes all leading/trailing spaces, and condenses any multiple in-between spaces to a single space.
  This formula is the Swiss Army knife for dealing with remove whitespace Excel challenges, covering most scenarios you’ll encounter.

VBA (Macros) for Automated Whitespace Removal

For recurring tasks, large datasets, or when you want to clean data in place without helper columns, VBA (Visual Basic for Applications) macros offer a powerful automation solution. This is particularly useful for those who frequently need to eliminate whitespace Excel wide or perform batch cleaning.

When to Use VBA

Large Datasets: Processing thousands or millions of cells can be slow with formulas. VBA is often faster.
In-Place Cleaning: If you don’t want to use helper columns and prefer to modify the data directly in the original cells.
Batch Processing: Cleaning multiple sheets or workbooks in one go.
Automated Processes: Integrating whitespace removal into a larger data preparation workflow.

Simple VBA Macro to Trim a Selection

This macro will apply the TRIM function to every cell in your selected range.

Open VBA Editor: Press Alt + F11.
Insert Module: In the VBA editor, go to Insert > Module.

Paste Code: Paste the following code into the module window:

Sub TrimSelectedCells()
    Dim cell As Range
    Application.ScreenUpdating = False ' Speeds up the macro by turning off screen updates

    For Each cell In Selection
        If Not IsEmpty(cell) Then ' Check if cell is not empty
            If cell.Value <> "" Then ' Ensure value is not already empty after trimming
                cell.Value = Trim(cell.Value)
            End If
        End If
    Next cell

    Application.ScreenUpdating = True ' Turn screen updates back on
    MsgBox "Selected cells have been trimmed!", vbInformation
End Sub

Run Macro:
- Go back to your Excel worksheet.
- Select the range of cells you want to clean.
- Press Alt + F8 to open the Macro dialog box.
- Select TrimSelectedCells and click Run.

This macro directly modifies your cells, so ensure you have a backup of your data before running it. Ai voice generator online free download

VBA Macro for More Robust Cleaning (TRIM + CLEAN + SUBSTITUTE)

For the ultimate cleanup incorporating non-breaking spaces and non-printable characters, you can adapt the VBA:

Sub RobustCleanSelectedCells()
    Dim cell As Range
    Dim cleanedText As String
    Application.ScreenUpdating = False

    For Each cell In Selection
        If Not IsEmpty(cell) Then
            cleanedText = CStr(cell.Value) ' Convert to string to handle various data types
            
            ' Replace non-breaking spaces (CHAR 160) with regular spaces
            cleanedText = Replace(cleanedText, Chr(160), " ")
            
            ' Remove non-printable characters
            cleanedText = Application.WorksheetFunction.Clean(cleanedText)
            
            ' Trim leading, trailing, and multiple internal spaces
            cleanedText = Trim(cleanedText)
            
            cell.Value = cleanedText
        End If
    Next cell

    Application.ScreenUpdating = True
    MsgBox "Selected cells have been robustly cleaned!", vbInformation
End Sub

This macro offers a powerful way to eliminate whitespace Excel data on a larger scale.

Removing Whitespace for Printing and Charting

A common question is how to “remove white space Excel print” or “remove white space Excel chart.” The key here is to understand that Excel’s printing and charting functions simply use the current content of the cells. They don’t have their own separate whitespace removal features.

Data Preparation is Key

To ensure your printed reports and charts look clean, you must clean the source data first.

Clean Your Data: Use TRIM, SUBSTITUTE, CLEAN, or a combination of these formulas as discussed earlier.
Paste as Values: Crucially, after applying formulas to a helper column, always paste the results back as values into your desired range (often replacing the original messy data). This converts the formulas into static text.
Verify: Once the data is pasted as values, check a few cells to confirm the whitespace is gone.

Impact on Printing

If your cell contains " Product A" after cleaning and pasting as values, it will simply become "Product A".
When you print this worksheet (Ctrl+P), the printed output will show “Product A” without the extra spaces, ensuring a professional appearance.

Impact on Charting

Charts, like bar charts or pie charts, use the text content of your cells for labels (e.g., axis labels, legend entries).
If your data labels are clean ("Region North" instead of " Region North "), your charts will also reflect this cleanliness. Clean labels make charts easier to read and understand, which is critical for effective data communication.

In essence, there’s no special trick for printing or charting beyond thoroughly cleaning your underlying data. Data integrity is the foundation of clear presentations, much like a solid financial plan is the foundation for a secure future. Json to tsv python

Best Practices and Tips for Whitespace Management

Beyond the specific formulas and VBA, adopting certain best practices can save you immense time and frustration in the long run.

Always Clean Data Upon Import

Make it a habit to run a whitespace cleaning routine whenever you import data from external sources. This proactive approach prevents issues from propagating through your spreadsheet. It’s like checking the quality of ingredients before cooking—a small effort upfront prevents major problems later.

Use Helper Columns

For most formula-based cleaning, using a helper column is highly recommended. It allows you to verify the cleaned data before overwriting your original information. This non-destructive approach is safer, especially for complex cleaning tasks.

Convert Formulas to Values

After your data is cleaned in a helper column, always convert the formulas to values using “Paste Special” > “Values.” This significantly reduces file size and improves Excel’s performance, as it no longer needs to calculate formulas in hundreds or thousands of cells. More importantly, it locks in your cleaned data, preventing accidental changes if source cells are modified or helper columns are deleted.

Understand the Source of Whitespace

If you repeatedly encounter specific types of whitespace (e.g., CHAR(160) from a particular website, or multiple spaces from a legacy system), try to understand the root cause. Sometimes, cleaning can happen at the data export stage or through a pre-processing script, reducing the need for extensive Excel cleaning. Convert csv to tsv windows

Data Validation for Future Input

For data entry, consider implementing data validation rules to prevent future whitespace issues. For example, you can use custom validation with a formula like =TRIM(A1)=A1 to ensure users don’t enter leading or trailing spaces. This proactive step can prevent new errors from creeping into your dataset.

Utilize Flash Fill (Excel 2013+)

For simple, consistent patterns, Excel’s Flash Fill feature (available from Excel 2013 onwards) can be incredibly powerful. If you have ” Product A ” in A1 and type “Product A” in B1, then start typing “Product B” in B2, Excel might suggest filling the rest of the column based on the pattern of removing spaces. This is an intuitive way to eliminate whitespace Excel if the pattern is obvious.

Regular Data Audits

Periodically audit your data for consistency and cleanliness. Even after initial cleanup, new data inputs or integrations can introduce inconsistencies. Just as regularly checking your financial statements is crucial for financial health, consistent data audits are vital for data integrity.

Conclusion: Data Purity as a Foundation

Managing whitespace in Excel is a fundamental skill for anyone working with data. By understanding the different types of whitespace and mastering functions like TRIM, SUBSTITUTE, and CLEAN, along with leveraging VBA for automation, you can transform messy datasets into clean, reliable information. This precision in data handling not only prevents frustrating errors but also empowers you to conduct more accurate analyses, create clearer reports, and make better-informed decisions. Just as the Prophet (peace be upon him) taught us that “cleanliness is half of faith,” data cleanliness is half of data integrity. Investing your time in these cleaning techniques is an investment in the quality and trustworthiness of your data, yielding dividends in efficiency and accuracy.

FAQ

What is whitespace in Excel and why is it a problem?

Whitespace in Excel refers to invisible characters like spaces, tabs, or line breaks that appear before, after, or between words in a cell. It’s a problem because Excel treats “Apple” and ” Apple ” as different entries, leading to issues with VLOOKUP, MATCH, sorting, filtering, and generally making your data inconsistent and unreliable. Csv to tsv linux

What is the simplest way to remove leading and trailing spaces in Excel?

The simplest way is to use the TRIM function. If your data is in cell A1, you would use the formula =TRIM(A1) in an adjacent cell. This will remove all leading and trailing spaces, and reduce multiple spaces between words to a single space.

How do I remove all spaces, including spaces between words, from a cell?

To remove every single space character from a cell, use the SUBSTITUTE function. The formula is =SUBSTITUTE(A1," ",""). This will replace all occurrences of a space with nothing, effectively eliminating them entirely.

Does `TRIM` remove non-breaking spaces (NBSP) in Excel?

No, TRIM does not remove non-breaking spaces, which are represented by character code 160 (CHAR(160)). TRIM only handles standard space characters (CHAR(32)). You need to use SUBSTITUTE to specifically target and remove non-breaking spaces.

What is a non-breaking space (NBSP) and how do I remove it?

A non-breaking space (NBSP) is a special type of space character (CHAR(160)) that looks identical to a regular space but isn’t treated the same way by TRIM. To remove it, use =SUBSTITUTE(A1,CHAR(160),""). For robust cleaning, you can combine this with TRIM, like =TRIM(SUBSTITUTE(A1,CHAR(160)," ")).

How can I remove non-printable characters like line breaks or tabs from Excel cells?

You can use the CLEAN function to remove most non-printable characters. The formula is =CLEAN(A1). For line breaks (CHAR(10)) or carriage returns (CHAR(13)) specifically, SUBSTITUTE can also be used: =SUBSTITUTE(A1,CHAR(10),""). Tsv to csv file

What is the most robust formula to clean all types of whitespace in Excel?

For a comprehensive clean-up, use a combination of TRIM, CLEAN, and SUBSTITUTE for non-breaking spaces: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," "))). This formula addresses non-breaking spaces, other non-printable characters, and standard leading/trailing/multiple internal spaces.

Can I remove whitespace from an entire column at once?

Yes, you can. Apply the desired cleaning formula (e.g., =TRIM(A1)) in the first cell of an adjacent empty column. Then, double-click the fill handle (the small green square at the bottom-right of the cell) to copy the formula down for the entire column. Finally, use “Paste Special” > “Values” to replace your original data with the cleaned results.

How do I remove whitespace without using a helper column?

You can remove whitespace without a helper column using VBA (macros). A VBA macro can directly modify the cell values in place. However, always back up your data before running a macro that alters cell content directly.

What is a VBA macro for trimming selected cells in Excel?

A simple VBA macro to trim selected cells is:

Sub TrimSelectedCells()
    Dim cell As Range
    For Each cell In Selection
        cell.Value = Trim(cell.Value)
    Next cell
End Sub

You can access the VBA editor by pressing Alt + F11, then insert a new module and paste this code. Select your cells and run the macro (Alt + F8). Tsv to csv in r

How does removing whitespace affect printing in Excel?

Removing whitespace directly affects the content of your cells. Once the data is cleaned (and ideally, pasted as values), Excel will use the clean text for printing. There isn’t a separate “remove white space Excel print” function; the printed output simply reflects the cleaned cell content.

Will cleaning whitespace impact my Excel charts?

Yes, if your chart labels or data series names are linked to cells that contain whitespace, cleaning those cells will update the chart accordingly. Clean labels and data make charts easier to read and more professional.

Can Flash Fill remove whitespace in Excel?

Yes, Flash Fill (available in Excel 2013 and later) can sometimes remove whitespace if it detects a consistent pattern. If you manually correct a few cells with whitespace and then start typing the corrected version, Flash Fill might auto-suggest the cleanup for the rest of your column. It’s an intuitive tool for simpler cases.

Is there a way to prevent users from entering whitespace in Excel?

Yes, you can use Data Validation. Select the column or range where you want to prevent whitespace. Go to Data > Data Validation > Custom and use a formula like =TRIM(A1)=A1 (assuming A1 is the first cell in your selected range). This will alert users if they try to enter leading or trailing spaces.

Why is `TRIM(CLEAN(cell))` a good combination for data cleaning?

TRIM(CLEAN(cell)) is effective because CLEAN removes non-printable characters (like line breaks) that TRIM doesn’t handle, and then TRIM removes standard leading/trailing spaces and condenses multiple internal spaces that CLEAN doesn’t affect. It’s a powerful one-two punch for general data cleanliness. Yaml to csv command line

Can whitespace affect numerical calculations?

Yes, if a “number” has leading/trailing spaces (e.g., ” 123″), Excel might treat it as text. This can cause errors in numerical calculations or prevent functions like SUM or AVERAGE from recognizing the value. Converting text to numbers after cleaning is often necessary for such cases.

What should I do after I’ve removed whitespace using formulas?

After using formulas in a helper column to remove whitespace, it’s highly recommended to:

Select the helper column.
Copy it (Ctrl+C).
Select the original column where you want the cleaned data.
Right-click and choose “Paste Special” > “Values” (Alt+E, S, V). This converts the formulas into static text, making your data permanent and improving performance.

Can I remove whitespace from multiple sheets at once?

Yes, using VBA macros is the most efficient way to remove whitespace from multiple sheets or even multiple workbooks simultaneously. You would typically write a loop in your macro to iterate through the desired sheets or files.

Why is it important to remove whitespace for data integrity?

Removing whitespace is crucial for data integrity because it ensures consistency, accuracy, and usability. Inconsistent data due to hidden spaces can lead to inaccurate reports, failed lookups, skewed analyses, and wasted time troubleshooting errors. It’s foundational for reliable data management.

Does Excel have a built-in feature to remove specific characters like tabs or line breaks without formulas?

No, Excel does not have a direct “remove tabs” or “remove line breaks” button. You generally need to use formulas like CLEAN or SUBSTITUTE for these specific characters, or utilize Find and Replace (Ctrl+H) with CHAR() functions (e.g., Ctrl+H, then in “Find what” type Ctrl+J for line breaks, leaving “Replace with” blank). Yaml to csv converter online

Remove whitespace excel