Highlight the cell(s) then do Edit Replace ReplaceWhat: ALT32 Replace
with: _ ReplaceAll

Note, when typing the 32 while holding down the ALT key, use the 3 and 2
keys on the KEYPAD, not those on the Keyboard....

Vaya con Dios,
Chuck, CABGx3



"nicole0904" wrote:


I want to check a cell to see if the text contains a space in it and if
it does I need to change that to an _. Can anyone help?


--
nicole0904
------------------------------------------------------------------------
nicole0904's Profile: http://www.excelforum.com/member.php...o&userid=31774
View this thread: http://www.excelforum.com/showthread...hreadid=514969