how do i remove extra space from a cell

Hi, 

Welcome to Microsoft Community! 

To remove extra spaces from a cell in Excel, you can use the TRIM function, which removes all extra spaces from text except for single spaces between words. 

1. Suppose your text is in cell A1.
2. In another cell, enter this formula: =TRIM(A1)
3. Press Enter.
4. Copy the result and use Paste Special > Values to replace the original if needed.

In case that TRIM doesn't work (e.g., due to non-breaking spaces), kindly use: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," "))) 

Whereas: 

• CHAR(160) is a non-breaking space.
• CLEAN removes non-printable characters

I hope you find the information above useful. Please let me know how it works. I'll be looking forward to your response. 

Best regards,       

Phoebe-N - MSFT | Microsoft Community Support Specialist

Hi,

The data in your worksheet may not contain only spaces, but also some invisible characters, so the TRIM or CLEAN function does not work well in your worksheet.

Try this formula:

=--TEXTJOIN("", TRUE, IFERROR(MID(A3, ROW(INDIRECT("1:" & LEN(A3)-3)), 1) + 0, ""))

Paste Only the Values into a new column as before and then format them, for example by adding a thousands separator and increase decimal.

Hope this helps.

Accounting error.xlsx

Kindly find the link above and review the sheet. Kindly suggest a one click solution.

Looking forward to your valuable suggestion please.

Thank You,

Jishub Bora

Regular users don't have the privilege to attach files here directly, you can ask the support team to initiate a private message for you and there will be an option to attach files.

And BTW you may consider uploading files to OneDrive and posting the share link here, which is a more efficient option.

I am writing to bring to your attention that I am currently unable to locate the "Attach File" option within the platform. This feature is essential for sharing relevant documents for supporting from your end , and its absence is impacting my ability to communicate effectively.

Dear Sir/Madam, Unfortunately, my problem is yet to be resolved.