| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting rid of those pesky white boxes...
Group,
I imported some data into Excel 2003. Some of the records contained "memo" fields, which contained long text entries. Inside these text entries are little white boxes (hard retrurns in the originating program), which, when copied and pasted into MS Word, turn into paragraph symbols. I want to remove them from Excel but I can't find a matching symbol to use in the search and replace process. Any ideas? TIA, Jeff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting rid of those pesky white boxes...
Jeff
Probably 0010 linefeeds. Try EditReplace What: CTRL + j With: leave blank or enter a space Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 14:38:02 -0800, Jeff Stouse wrote: Group, I imported some data into Excel 2003. Some of the records contained "memo" fields, which contained long text entries. Inside these text entries are little white boxes (hard retrurns in the originating program), which, when copied and pasted into MS Word, turn into paragraph symbols. I want to remove them from Excel but I can't find a matching symbol to use in the search and replace process. Any ideas? TIA, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
| Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
| EXCEL workbook is off-white, goes white in edit mode | Excel Discussion (Misc queries) | |||
| Pesky VLookup !!! | Excel Worksheet Functions | |||
| Pesky little problem with no solution? | Excel Worksheet Functions | |||
Linear Mode
