| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get rid of line feed characters in wrapped text?
I have to use a database which has been imported into Excel. In one of the
fields the address details appear as wrapped text. When I unwrap the text there is a "square" character between the 2 parts of the field. How do I get rid of this? All assistance appreciated, thanks. |
|
#2
|
|||
|
|||
|
Glad
The boxes are probably carriage returns. In Excel, try EditReplace what: ALT + 0010(on numpad) with: space(or nothing) OR ALT + 0013 If this doesn't work, post back. There are other avenues of approach. Gord Dibben Excel MVP On Mon, 17 Jan 2005 09:23:02 -0800, "Gladmac" wrote: I have to use a database which has been imported into Excel. In one of the fields the address details appear as wrapped text. When I unwrap the text there is a "square" character between the 2 parts of the field. How do I get rid of this? All assistance appreciated, thanks. |
|
#3
|
|||
|
|||
|
Thanks Gord.
Worked perfectly! "Gord Dibben" wrote: Glad The boxes are probably carriage returns. In Excel, try EditReplace what: ALT + 0010(on numpad) with: space(or nothing) OR ALT + 0013 If this doesn't work, post back. There are other avenues of approach. Gord Dibben Excel MVP On Mon, 17 Jan 2005 09:23:02 -0800, "Gladmac" wrote: I have to use a database which has been imported into Excel. In one of the fields the address details appear as wrapped text. When I unwrap the text there is a "square" character between the 2 parts of the field. How do I get rid of this? All assistance appreciated, thanks. |
|
#4
|
|||
|
|||
|
Thanks for the feedback.
Always nice to know what does or doesn't do the job. Gord On Mon, 17 Jan 2005 21:43:01 -0800, "Gladmac" wrote: Thanks Gord. Worked perfectly! "Gord Dibben" wrote: Glad The boxes are probably carriage returns. In Excel, try EditReplace what: ALT + 0010(on numpad) with: space(or nothing) OR ALT + 0013 If this doesn't work, post back. There are other avenues of approach. Gord Dibben Excel MVP On Mon, 17 Jan 2005 09:23:02 -0800, "Gladmac" wrote: I have to use a database which has been imported into Excel. In one of the fields the address details appear as wrapped text. When I unwrap the text there is a "square" character between the 2 parts of the field. How do I get rid of this? All assistance appreciated, thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted blank line in cell with wrapped text | Excel Discussion (Misc queries) | |||
| Text import out of line? | Excel Discussion (Misc queries) | |||
| Wrapped text appears as xxxxxx | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
Linear Mode
