Help! Removing a Space in Excel

reexreplace

https://support.microsoft.com/zh-cn/office/regexreplace-%E5%87%BD%E6%95%B0-9c030bb2-5e47-4efc-bad5-4582d7100897#:~:text=%E4%BD%BF%E7%94%A8%20REGEXREPLACE%20%E5%87%BD%E6%95%B0%EF%BC%8C%E5%8F%AF%E4%BB%A5%E6%A0%B9%E6%8D%AE%E6%8F%90%E4%BE%9B%E7%9A%84%E6%AD%A3%E5%88%99%E8%A1%A8%E8%BE%BE%E5%BC%8F%20%28%E2%80%9Cregex%E2%80%9D%29%20%E5%B0%86%E5%AD%97%E7%AC%A6%E4%B8%B2%E4%B8%AD%E7%9A%84%E6%96%87%E6%9C%AC%E6%9B%BF%E6%8D%A2%E4%B8%BA%E5%8F%A6%E4%B8%80%E4%B8%AA%E5%AD%97%E7%AC%A6%E4%B8%B2%E3%80%82%20REGEXREPLACE%20%E5%87%BD%E6%95%B0%E6%9B%BF%E6%8D%A2%E6%89%80%E6%8F%90%E4%BE%9B%E7%9A%84%20%E6%96%87%E6%9C%AC,%E6%9B%BF%E6%8D%A2%E6%A8%A1%E5%BC%8F%20%E5%8C%B9%E9%85%8D%E7%9A%84%E5%AD%97%E7%AC%A6%E4%B8%B2%E3%80%82%20REGEXEXTRACT%20%E5%87%BD%E6%95%B0%E7%9A%84%E8%AF%AD%E6%B3%95%E4%B8%BA%EF%BC%9A%20REGEXREPLACE%20%28text%E3%80%81pattern%E3%80%81replacement%E3%80%81%20%5Boccurrence%5D%E3%80%81%20%5Bcase_sensitivity%5D%29

I copy your data and paste to my Excel. I found that you have hidden character rather than space which represent Char(160). So, use SUBSTITUTE() function to remove those chars like-

=SUBSTITUTE(A2,CHAR(160),"")

If, in your real file you have only spaces (more than one) then use the following formula-

=TEXTJOIN(" ",1,TEXTSPLIT(A3," "))

If this is in a single column, for example in D1:D12000:

In an empty column, enter the following formula in the cell in row 1:

=TRIM(D1:D12000)

The formula result will spill down to row 12000.

Select the result, copy it, then paste as values over D1:D12000.

You can now clear the column with the formulas.

If the data are in multiple columns, you might use a macro (in the desktop version of Excel).

Let me know if you need that.