Forum Discussion

ARosengard's avatar
ARosengard
Copper Contributor
Aug 08, 2025

Help! Removing a Space in Excel

Hi group. Need some help here. I have 12000 records that need to have a space removed.   Precision T3600  (Dell) As you can see, there is more than one space between 3600 and (Dell) I need to...
excel
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 09, 2025

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," "))

 

Resources