FG
💻 Software

How to set a character limit and remove characters over that limit excel 2007

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

Problem

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max. I have a list of names/numbers, but the numbers have spaces and the names are full names. Is there a way to remove character…

Error Output

+------------ NAME ------------+--- NUMBER ---+
| johnathan ferguson suppliers | 01234 567899 |
| johnathan ferguson suppliers | 01234 567899 |

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to set a character limit and remove characters over that limit excel 2007

Low Risk

Found the answer for character limit: Where A1 is the column with the full text in, and 20 is the character limit now set. answer for removing spaces: Where C3 is your phone number with spaces.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment