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
peiyezhu's avatar
peiyezhu
Bronze Contributor
Aug 09, 2025

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

 

Resources