How do I remove ALT+ENTER in same cell?

[Govindareddy]

I have hit ALT+ENTER to seperate lines in same cell. I need to remove this -
don't know how to remove this from a saved file.

 

[RagDyeR]

Position place holder at the end of each line and hit <Delete>.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have hit ALT+ENTER to seperate lines in same cell. I need to remove
this -
don't know how to remove this from a saved file.

 

[Gord Dibben]

Edit>Replace

What: CTRL + j ...hold CTRL key and hit j

With: nothing

Replace All


Gord Dibben MS Excel MVP

 

[TGV]

It can be done in two ways:-

1) you can manually go to the end of ur cell data and give delete to remove
it.
2) If the data is more then use this formula to remove the ALT+ENTER

=CLEAN(TRIM(A1))

change the cell reference A1 to ur desired Cell.

 

[Jacob Skaria]

Use this formula
=SUBSTITUTE(E14,CHAR(10),CHAR(32))

OR

Use the below macro which works on the active sheet

Sub Macro()
For Each cell In ActiveSheet.UsedRange
If InStr(cell, Chr(10)) <> 0 Then _
cell.Value = Replace(cell.Text, Chr(10), Chr(32))
Next
End Sub

If you are new to macros Set the Security level to low/medium in
(Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below code. Save. Get back to
Workbook. Run macro from Tools|Macro|Run <selected macro()>

If this post helps click Yes

 

[Dave Peterson]

It may better to replace it with a space character--unless the OP wants to run
the words together.