| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a hard return in a cell
how do I remove a hard return from a cell?
A find and replace mechanism for it would be great! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a hard return in a cell
you can type =clean(cell name) to remove the formatting. Course, this would
also remove all spaces... "slickrok" wrote: how do I remove a hard return from a cell? A find and replace mechanism for it would be great! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a hard return in a cell
Select cell(s)
Edit | Find/replace In Replace What enter Alt+0010 In With What - leave blank best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "slickrok" wrote in message ... how do I remove a hard return from a cell? A find and replace mechanism for it would be great! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a hard return in a cell
If by a hard return you mean Alt-Enter, then Edit/ Replace/ Find what:
Control J/ Replace with: [nothing] -- David Biddulph "slickrok" wrote in message ... how do I remove a hard return from a cell? A find and replace mechanism for it would be great! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HARD RETURN IN A CELL | Excel Discussion (Misc queries) | |||
| How do I split a one cell which has a hard return? | Excel Discussion (Misc queries) | |||
| How do I make a hard return within a cell in Excel? | New Users to Excel | |||
| How do I insert a "hard return" in a cell? | Excel Discussion (Misc queries) | |||
| Is is possible to add a hard return to a merge cell formula? | Excel Discussion (Misc queries) | |||
Linear Mode
