FG
💻 Software

How to remove white space from a number

Fresh6 days ago
Mar 15, 2026114617 views
Confidence Score0%
0%

Problem

I have a column of number with white spaces in them. Like this: " ". How do I get rid of all the white space to get excel to treat it as numbers rather than strings? EDIT: Let me fill in some additional information that has come to light. My goal is to turn " " into a 32445423. If I write in the st…

Error Output

32 445 423

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to remove white space from a number

Low Risk

I believe your imported data includes non-breaking spaces instead of standard spaces. Hence, the formula does not work. Instead of using the space bar to type the in the SUBSTITUTE formula, try a non-breaking space. You can select this in the Charac…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment