| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing a hard line break in Excel
Hi,
I have a pretty large spreadsheet. The person that originally created it didn't know how to use word wrap so they inserted hard breaks in cells to get it to wrap. Now, I want to get rid of this. How can I replace a hard break? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing a hard line break in Excel
=SUBSTITUTE(A2,CHAR(10)," ")
This will replace hard break with a space. If you want it completely wiped out use "" instead of " ". HTH Kostis Vezerides a_ryan1972 wrote: Hi, I have a pretty large spreadsheet. The person that originally created it didn't know how to use word wrap so they inserted hard breaks in cells to get it to wrap. Now, I want to get rid of this. How can I replace a hard break? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing a hard line break in Excel
When I try to paste this code into the cell, it wipes out what's in the
entire cell. If I try to paste this code into the find and replace, it doesn't allow me to. Am I doing this wrong? Thanks. "vezerid" wrote: =SUBSTITUTE(A2,CHAR(10)," ") This will replace hard break with a space. If you want it completely wiped out use "" instead of " ". HTH Kostis Vezerides a_ryan1972 wrote: Hi, I have a pretty large spreadsheet. The person that originally created it didn't know how to use word wrap so they inserted hard breaks in cells to get it to wrap. Now, I want to get rid of this. How can I replace a hard break? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing a hard line break in Excel
This may work:
Select the range to fix Edit|replace what: ctrl-j with: (spacebar) (or whatever you want) replace all. This edit|Replace will fail on cells that have lots and lots of characters, though. a_ryan1972 wrote: Hi, I have a pretty large spreadsheet. The person that originally created it didn't know how to use word wrap so they inserted hard breaks in cells to get it to wrap. Now, I want to get rid of this. How can I replace a hard break? Thank you. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing a hard line break in Excel
That worked, thank you.
"Dave Peterson" wrote: This may work: Select the range to fix Edit|replace what: ctrl-j with: (spacebar) (or whatever you want) replace all. This edit|Replace will fail on cells that have lots and lots of characters, though. a_ryan1972 wrote: Hi, I have a pretty large spreadsheet. The person that originally created it didn't know how to use word wrap so they inserted hard breaks in cells to get it to wrap. Now, I want to get rid of this. How can I replace a hard break? Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting line by line matches of 2 columns possible in excel ? | Excel Discussion (Misc queries) | |||
| How do I get a line break when using a formula to combine cells | Excel Worksheet Functions | |||
| Why can't I get 'alt enter' to create a line break in Excel? | Excel Discussion (Misc queries) | |||
| Line break in X-axis column label? | Charts and Charting in Excel | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Linear Mode
