Changing characters in a cell
 

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

Changing characters in a cell
 

Using a formula:

=substitute(a1," ","_")

(why bother checking??)

Or just select the range to inspect and
edit|replace
what: (spacebar)
with: _
replace all



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

--

Dave Peterson

Changing characters in a cell
 

Use the SUBSTITUTE( ) function, such as:

=SUBSTITUTE(A1," ","_")

if your data is in A1.

Hope this helps.

Pete

Changing characters in a cell
 

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

Changing characters in a cell
 

Why not just hit the spacebar in the What box?

CLR wrote:

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



--

Dave Peterson

Changing characters in a cell
 

="Because"&CHAR(32)&"my"&CHAR(32)&"spacebar"&CHAR( 32)&"is"&CHAR(32)&"broken?€¦€¦.<g"


Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote:

Why not just hit the spacebar in the What box?

CLR wrote:

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



--

Dave Peterson