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.

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!
================================================== ===

"Govindareddy" wrote in message
...
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.

EditReplace

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

With: nothing

Replace All


Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 08:59:01 -0700, Govindareddy
wrote:

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.

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.

--
If this post helps, pls click Yes
---------------
TGV


"Govindareddy" wrote:

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.

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
---------------
Jacob Skaria


"Govindareddy" wrote:

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.

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

Gord Dibben wrote:

EditReplace

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

With: nothing

Replace All

Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 08:59:01 -0700, Govindareddy
wrote:

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.

--

Dave Peterson