Remove "Alt Enter" blank space

From a cell, how to remove a "blank line" that is enter by Alt enter
keystroke!

Using Visual Basic!
"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:e%23I5BWGDFHA.1264@TK2MSFTNGP12.phx.gbl...
> From a cell, how to remove a "blank line" that is enter by Alt enter
> keystroke!
>

Hi

one way

Sub removealtenter()
For Each c In Range("A1:A10")
c.Value = Application.WorksheetFunction.Substitute(c.Value, Chr(10),
" ")
Next
End Sub

Cheers
JulieD

"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:OXa7SXGDFHA.936@TK2MSFTNGP12.phx.gbl...
> Using Visual Basic!
> "crapit" <littlecramP@yahoo.com.sg> wrote in message
> news:e%23I5BWGDFHA.1264@TK2MSFTNGP12.phx.gbl...
>> From a cell, how to remove a "blank line" that is enter by Alt enter
>> keystroke!
>>
>
>

Wat abt removing it from a 2nd "Alt-Enter" only?
"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:uia5UcGDFHA.2032@tk2msftngp13.phx.gbl...
> Hi
>
> one way
>
> Sub removealtenter()
> For Each c In Range("A1:A10")
> c.Value = Application.WorksheetFunction.Substitute(c.Value,
> Chr(10), " ")
> Next
> End Sub
>
> Cheers
> JulieD
>
> "crapit" <littlecramP@yahoo.com.sg> wrote in message
> news:OXa7SXGDFHA.936@TK2MSFTNGP12.phx.gbl...
>> Using Visual Basic!
>> "crapit" <littlecramP@yahoo.com.sg> wrote in message
>> news:e%23I5BWGDFHA.1264@TK2MSFTNGP12.phx.gbl...
>>> From a cell, how to remove a "blank line" that is enter by Alt enter
>>> keystroke!
>>>
>>
>>
>
>

you're welcome .. check out the substitute function either in VBA or normal
excel help ... it will show how to do this.

Cheers
JulieD

"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:ea5dYTXJFHA.4028@tk2msftngp13.phx.gbl...
> Wat abt removing it from a 2nd "Alt-Enter" only?
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:uia5UcGDFHA.2032@tk2msftngp13.phx.gbl...
>> Hi
>>
>> one way
>>
>> Sub removealtenter()
>> For Each c In Range("A1:A10")
>> c.Value = Application.WorksheetFunction.Substitute(c.Value,
>> Chr(10), " ")
>> Next
>> End Sub
>>
>> Cheers
>> JulieD
>>
>> "crapit" <littlecramP@yahoo.com.sg> wrote in message
>> news:OXa7SXGDFHA.936@TK2MSFTNGP12.phx.gbl...
>>> Using Visual Basic!
>>> "crapit" <littlecramP@yahoo.com.sg> wrote in message
>>> news:e%23I5BWGDFHA.1264@TK2MSFTNGP12.phx.gbl...
>>>> From a cell, how to remove a "blank line" that is enter by Alt enter
>>>> keystroke!
>>>>
>>>
>>>
>>
>>
>
>

Non-macro.

edit|replace
what: (hit and hold the alt key and type 0010 from the numeric keypad)
with: (leave blank or a spacebar???)
replace all

It may not look like that alt-0010 did anything, but try it. It'll work.

As a formula:

=substitute(a1,char(10),"")
or
=substitute(a1,char(10)," ")

If you want a space character.


crapit wrote:
>
> From a cell, how to remove a "blank line" that is enter by Alt enter
> keystroke!

--

Dave Peterson

Ah, VBA.

Never mind.

Dave Peterson wrote:
>
> Non-macro.
>
> edit|replace
> what: (hit and hold the alt key and type 0010 from the numeric keypad)
> with: (leave blank or a spacebar???)
> replace all
>
> It may not look like that alt-0010 did anything, but try it. It'll work.
>
> As a formula:
>
> =substitute(a1,char(10),"")
> or
> =substitute(a1,char(10)," ")
>
> If you want a space character.
>
> crapit wrote:
> >
> > From a cell, how to remove a "blank line" that is enter by Alt enter
> > keystroke!
>
> --
>
> Dave Peterson

--

Dave Peterson