How do I remove ALT+ENTER in same cell?
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. |
How do I remove ALT+ENTER in same cell?
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. |
How do I remove ALT+ENTER in same cell?
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. |
How do I remove ALT+ENTER in same cell?
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. |
How do I remove ALT+ENTER in same cell?
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. |
How do I remove ALT+ENTER in same cell?
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 |
All times are GMT +1. The time now is 02:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com