Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JB2006
 
Posts: n/a
Default 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 " ".

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default 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 " ".



  #3   Report Post  
Posted to microsoft.public.excel.newusers
JB2006
 
Posts: n/a
Default How can I replace spaces in text cells (excel) with underscore

That worked well, many thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Truncated wrapped text cells in Excel RichK Excel Discussion (Misc queries) 1 April 12th 06 07:45 PM
How do I replace the last entire word in text cells? George Excel Discussion (Misc queries) 6 December 15th 05 08:30 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Text cells in excel Julie KD Excel Discussion (Misc queries) 1 May 19th 05 11:52 PM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 12:22 AM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"