ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How can I replace spaces in text cells (excel) with underscores? (https://www.excelbanter.com/new-users-excel/84259-how-can-i-replace-spaces-text-cells-excel-underscores.html)

JB2006

How can I replace spaces in text cells (excel) with underscores?
 
I've tried searching for " " and replacing it with _ but excel doesn't find
any spaces with " ".


Ardus Petus

How can I replace spaces in text cells (excel) with underscores?
 
use "~ " (tilde space - no quotes

HTH
--
AP

"JB2006" a écrit dans le message de
...
I've tried searching for " " and replacing it with _ but excel doesn't

find
any spaces with " ".




JB2006

How can I replace spaces in text cells (excel) with underscore
 
That worked well, many thanks!


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com