On Aug 1, 5:24 am, "Jim Cone" wrote:
Sub FillInTheBlanks()
Dim str As String
str = "abc xyz"
str = Application.Substitute(str, " ", "_")
MsgBox str
End Sub
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Madiya"
wrote in message
Hi Jim,
Got the error.
The name is not valid (name should not contain any blank cherecter).
Is there any way I can convert any text in cell containing space to
"_"
For example, say I have a text "abc xyz" which should get converted in
"abc_xyz"
Regards,
Madiya

Thank you dear Jim.
My job is done with your help.

Regards,
Madiya