Yep, it was a shot in the dark.
we are awaiting the return of our MVP in MSWorks.
Thanks Gord.



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| I can only speak for Excel, not MS Works.
|
| Since you posted in an Excel news group, I suggested an Excel fix.
|
| If it doesn't help in Works, perhaps a trip to an MS Works news group would
| serve you better.
|
| http://aumha.org/nntp.htm for a list of groups.
|
|
| Gord
|
| On Sat, 21 May 2005 08:43:08 +0800, "Rodney" wrote:
|
| G'day Gordon,
| here is the enigma.........
| http://cjoint.com/data/fvcUQjBTfO.htm
|
| What we seek is to remove the little square boxes,
| It looks impossible, apart from individually going to
| the cell and deleting.
|
| Edit / Replace and using the num pad will not work in MSWorks
|
| Here is the OP post..............
|
| I read sometime ago in a magazine what I think was the answer to this
| question.
| I wish I had written it down at the time
| The reason I want this is I import the data for the field from Eudora,
| Its the output of a form on my website, and regularly people put and
| "End of Line" character in the form by pressing enter.
| The EoL then poses a problem in my database and I have to remove them.
| I would like to search and replace if I could rather than doing it all
| one by one.
|
|
| "Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| | Rodney
| |
| | What did you try for the "replace" option that did not work?
| |
| | In Excel you would EditReplace
| |
| | What: ALT + 0010 (on NumPad)
| |
| | With: nothing
| |
| | Replace all.
| |
| |
| | Gord Dibben Excel MVP
| |
| | On Fri, 20 May 2005 10:07:45 +0800, "Rodney" wrote:
| |
| |
| | We are using Excel's sibling MSWorks
| | and have a curious problem.
| | In a Database cell, we can add lines to the cell
| | in "Report View" by employing an "End Of Line" character.
| | (In Excel it's the same with ALT/Enter)
| |
| | In MSWorks "list view" the EOL character appears as a square box.
| |
| | What we need to know is there anyway of removing
| | this EOL character (the square box) "en-masse"
| | Seems a singular physical delete is the only option.
| |
| | We have tried the "replace" option, no good
| |
| | Our resident MVP is away at the mo, so thought I'd chance a request here.
| |
| | Anybody?
| |
| | Thanks
| |
| |
| |
|
|